| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find last row code
Try this:
Sheets(activesheet.name).Cells(Last(1, ActiveSheet.Cells), "m").Select |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find last row code
Thanks Dave. This worked great. Sorry about the multiple postings.
Couldn't see my question. "Dave O" wrote: Try this: Sheets(activesheet.name).Cells(Last(1, ActiveSheet.Cells), "m").Select |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I find a code in Excel | Excel Worksheet Functions | |||
| Code using A sheet to find a number | Excel Discussion (Misc queries) | |||
| database to Find customer by zip code | Excel Discussion (Misc queries) | |||
| Why code for find() is not working | Excel Discussion (Misc queries) | |||
| Find the cell value in excel by using vb code | Excel Discussion (Misc queries) | |||
Linear Mode
