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

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...

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...