Thread: Is filtered property?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
L2B L2B is offline
external usenet poster
  
Posts: 1
Default Is filtered property?

Hi,

I would like to check a new autofiltered list versus an old version for
any changes. Is there an isvisible property in VBA that can detect
whether an item is now visible and was visible in a previous saved
version.

e.g. row 10 has item "fdgfs" which today is not filtered out, how can i
check whether in the previous spreadsheet this was visible also, (the
filtering is based on 5+ criteria)

Many thanks,

Liz


--
L2B
------------------------------------------------------------------------
L2B's Profile: http://www.excelforum.com/member.php...o&userid=23140
View this thread: http://www.excelforum.com/showthread...hreadid=386051

Reply With QuoteReply With Quote