Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cells.Find in Auto-Filtered range
Hello.
It appears that Cells.find only looks in the visible range of the spreadsheet... for instance, if there is something in some rows of column G, but those rows are currently not visible due to use of auto-filter, a search to look for the last used column will return an entry in column F. An alternative would be the Activesheet object, but it returns the last used column since the last save, not the truly last used colum at the moment. is there a method similar to the FIND method which looks in hidden areas, too? Thanks. Mark |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cells.Find in Auto-Filtered range
doing it another way.
thanks anyway. -----Original Message----- Hello. It appears that Cells.find only looks in the visible range of the spreadsheet... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cells.Find in Auto-Filtered range
doing it another way.
thanks anyway. -----Original Message----- Hello. It appears that Cells.find only looks in the visible range of the spreadsheet... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count only cells within Filtered Range | Excel Worksheet Functions | |||
sum of visable cells in filtered range | Excel Worksheet Functions | |||
Find a range of values in a range of cells | Excel Worksheet Functions | |||
Excel auto filtering to find a range of dates in a list | Excel Discussion (Misc queries) | |||
average of visible cells in a filtered range | Excel Worksheet Functions |