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