finding last filled row

[akkinarula]

hi all,

i have to write a macro on sheet 2 which shall be itterate as per the rows in the sheet1.
from where shall i get the last row no of sheet1.
sheet1's row number changes dynamically.

i m using ms excell 2003

thanks in advance

 

[VoG]

Try like this

LR = Sheets("Sheet1").Range("A" & Rows.Count).End(xlUp).Row

 

[pushkardey]

Lst_row=thisworkbook.sheets("Sheet1").Range("A65536").End(xlUp).Row

There are a few more methods... let me know if you have any apecific requirement...

 

[akkinarula]

Try like this

LR = Sheets("Sheet1").Range("A" & Rows.Count).End(xlUp).Row

thanks this worked

 

[akkinarula]

Lst_row=thisworkbook.sheets("Sheet1").Range("A65536").End(xlUp).Row

There are a few more methods... let me know if you have any apecific requirement...

thanks