ExcelBanter - View Single Post - Find last row code

Thread: Find last row code

View Single Post

#2

Report Post

Posted to microsoft.public.excel.misc

Dave O[_2_] Dave O[_2_] is offline

Dave O[_2_] is offline

external usenet poster

Posts: 19

Default

Find last row code

Try this:
Sheets(activesheet.name).Cells(Last(1, ActiveSheet.Cells),
"m").Select

Reply With Quote

Reply With Quote