Plz,

I am trying to use this, but getting error!

I need to get the last active row in the active sheet

Dim LastRow As Integer

LastRow
Workbooks(ActiveWorkbook.Name).Worksheets(ActiveSh eet).Cells(Rows.Count
"1").End(xlUp).Row

May be its because of the "1" ???

Thanks

--
Message posted from http://www.ExcelForum.com