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

There is not Filtered property, as far as I know. I think all you can do is
check whether a row is hidden:

Sub aa()
Dim Rw As Range
With ActiveSheet.AutoFilter.Range
For Each Rw In .Rows
If Rw.Hidden Then MsgBox Rw.Address & " is filtered"
Next
End With
End Sub

You might want to use something similar to build an array of hidden rows
with each filter applied, and then compare arrays to see what changed.

--
Jim
"L2B" wrote in message
...
|
| 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
|