M
mark
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
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