| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Last Row Hidden
It looks to me (in my ignorance) as if Excel is doing exactly as
requested. Try this one on your sheet with rows hidden. Once again Excel wins. :- '--------------------------------------------------------------------- Set foundcell = ActiveSheet.Cells.Find(What:="*", _ SearchDirection:=xlPrevious, SearchOrder:=xlByRows) MsgBox (foundcell.Row) '----------------------------------------------------------------------- It's the way we ask. This is definitely one (two) for the archives. Thanks for the observation ! --- Message posted from http://www.ExcelForum.com/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i find out what data is hidden i excel | Excel Worksheet Functions | |||
| Find last row with hidden rows | Excel Discussion (Misc queries) | |||
| how to find out if a row is hidden | Excel Worksheet Functions | |||
| find hidden data in worksheet | Excel Worksheet Functions | |||
| How to find hidden text | Excel Worksheet Functions | |||
Threaded Mode
