Excel VBA

If you have the number of rows specified as a variable (NumOfRows) then

Range(activecell.address, activecell.offset(NumOfRows,0).address).select

Otherwise if you want to select 6 rows, you need to offset your selection by 5 rows as shown below:

Range(activecell.address, activecell.offset(5,0).address).select


Generally:

Range(activecell.address, activecell.offset(NumOfRows,NumOfColumns).address).select

where NumOfRows and NumOfColumns are the EXTRA rows and columns you want to select IN ADDITION TO the currently selected cell.