| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find last row with hidden rows
I am using the following code to find the last row of a worksheet. It works
fine as long as the last used row is unhidden. But it I hide it, then this does not work as I want. I need to find the absolute last row whether it is hidden or unhidden. Can anyone help? FindLastRow = objSheet.Cells.SpecialCells(xlCellTypeLastCell).Ro w |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find last row with hidden rows
Try
lastrow = Cells.Find(What:="*", After:=[A1], SearchDirection:=xlPrevious).Row Mike "Sherry" wrote: I am using the following code to find the last row of a worksheet. It works fine as long as the last used row is unhidden. But it I hide it, then this does not work as I want. I need to find the absolute last row whether it is hidden or unhidden. Can anyone help? FindLastRow = objSheet.Cells.SpecialCells(xlCellTypeLastCell).Ro w |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find last row with hidden rows
Works GREAT! Thank you.
"Mike H" wrote: Try lastrow = Cells.Find(What:="*", After:=[A1], SearchDirection:=xlPrevious).Row Mike "Sherry" wrote: I am using the following code to find the last row of a worksheet. It works fine as long as the last used row is unhidden. But it I hide it, then this does not work as I want. I need to find the absolute last row whether it is hidden or unhidden. Can anyone help? FindLastRow = objSheet.Cells.SpecialCells(xlCellTypeLastCell).Ro w |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hidden rows columns won't stay hidden | Excel Worksheet Functions | |||
| Formula or Code to keep Hidden Rows Hidden | Excel Worksheet Functions | |||
| I need my Hidden Rows to stay hidden when I print the sheet. | Excel Discussion (Misc queries) | |||
| Excel 2003 -Rows hidden. Scrolling unhides rows ! How do I stop th | Excel Discussion (Misc queries) | |||
| deleting hidden rows so i can print only the rows showing?????? | Excel Worksheet Functions | |||
Hybrid Mode
