Last row as value
 

Hi all,

Is there a way to get the last used cell's row number as value? For example,
if the last used cell is in the 78th row, I could get 78 as value.

thanks in advance!
--
sisco98

Last row as value
 

If you want the last row in column A try:

lastRowNo = Range("A65536").End(xlUp).Row


"sisco98" wrote in message
...
Hi all,

Is there a way to get the last used cell's row number as value? For
example,
if the last used cell is in the 78th row, I could get 78 as value.

thanks in advance!
--
sisco98

Last row as value
 

Either

Range("A2"),End(xlDown).Row

if there are no blanks in the data, otherwise

Cells(Rows.Count,"A").End(xlUp).Row

--
HTH

Bob Phillips

"sisco98" wrote in message
...
Hi all,

Is there a way to get the last used cell's row number as value? For
example,
if the last used cell is in the 78th row, I could get 78 as value.

thanks in advance!
--
sisco98

Last row as value
 

thanks for both tips!
--
sisco98


"Bob Phillips" wrote:

Either

Range("A2"),End(xlDown).Row

if there are no blanks in the data, otherwise

Cells(Rows.Count,"A").End(xlUp).Row

--
HTH

Bob Phillips

"sisco98" wrote in message
...
Hi all,

Is there a way to get the last used cell's row number as value? For
example,
if the last used cell is in the 78th row, I could get 78 as value.

thanks in advance!
--
sisco98