Selecting last row after the row having some data

[Raj999]

Hi All,

I would like to select a row after the last active row in the excel sheet. for example: imagine I have data till a row say 151 and i would like to select row 152. the number of rows in my worksheet always varies.

Thanks,
Raj

 

[abmati]

If you wish to go last row (A151) of A column where range is A1:151
select cell A1, press "End key" then press "Down Arrow" key
OR
Use vba as under:
Range("A" & Rows.Count).End(xlUp).

 

[Rick Rothstein]

Either one of these code lines will do what you want, see the note at the end to decide on which to use..

For last value
---------------
Cells.Find("*", , xlValues, , xlRows, xlPrevious).Offset(1).EntireRow.Select

For last value or formula
------------------------------
Cells.Find("*", , xlFormulas, , xlRows, xlPrevious).Offset(1).EntireRow.Select

A note about those headings... the ones labeled "For last value" means it will return the last used row and column for a displayed value (whether a constant or one from a formula) even if there are formulas after those cells displaying the empty string (""); whereas those labeled "For last value or formula" returns the last cell with either a value or a formula even if that formula is displaying the empty string ("").