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

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" <[email protected]> wrote in message
news:[email protected]...
|
| 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
|