View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike Milmoe Mike Milmoe is offline
external usenet poster
 
Posts: 23
Default Find last row code

I have the following code to find the last row with data. It works
perfectly. However, how can I make it work on any sheet, essentially the
active tab, as opposed to a specific sheet as in the below example.

Sheets("HI01").Cells(Last(1, ActiveSheet.Cells), "m").Select