In XL97, the following find statement ignores rows that have
been hidden by the AdvancedFilter:
x = sh.Cells.Find(what:="*", after:=Range("IV65536"
, _
searchorder:=xlByRows, searchdirection:=xlPrevious).Row
Anybody know a way around this? The intent of the statement is to find the last row (visible or not) on worksheet object "sh" that actually has cell contents (I'm not interested in cells that have formatting applied but no contents, or in Excels native attempts to track used ranges).
Thanks!
VBAjedi![[swords] [swords] [swords]](/data/assets/smilies/swords.gif)
been hidden by the AdvancedFilter:
x = sh.Cells.Find(what:="*", after:=Range("IV65536"
searchorder:=xlByRows, searchdirection:=xlPrevious).Row
Anybody know a way around this? The intent of the statement is to find the last row (visible or not) on worksheet object "sh" that actually has cell contents (I'm not interested in cells that have formatting applied but no contents, or in Excels native attempts to track used ranges).
Thanks!
VBAjedi
![[swords] [swords] [swords]](/data/assets/smilies/swords.gif)