You can check the worksheet's FilterMode property - if it's True then
ShowAllData.


Ted M H;721279 Wrote:

I need a way to clear any and all AdvancedFilter on a worksheet so that
all
rows are displayed. I've tried the ShowAllData method and it works
fine as
long as there are filtered rows on the sheet. But the method fails if
there
are no filtered rows.

Is there a way ShowAllData regardless of whether rows are filtered? If
not,
is there a way to check for AdvancedFilter--a sort of AdvancedFilter
property?

Many thanks.


--
aflatoon

Regards,
A.
------------------------------------------------------------------------
aflatoon's Profile: http://www.thecodecage.com/forumz/member.php?u=1501
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=201955

http://www.thecodecage.com/forumz