Filtered list row properties

Posted by Paul on January 29, 2001 5:56 AM

Does anyone know what properties are set on a row when an autofilter is being ran?

Thanks

Paul

Posted by Robert Faass on January 30, 2001 2:56 PM

The autofilter property is true, and each row not vissible, the hidden property of the row is true.

OK?

Posted by Paul on January 31, 2001 9:37 AM

If ActiveSheet.FilterMode = True Then
if Worksheets("sheetname").Rows(rownumber).Hidden = True then
' do stuff here
end if
end if

Thanks you answered that question, but I am still unable to do what I want. TO swap out the filtered rows, I keep getting an out of range error, I think because Autofilter is on.

Thanks,

Paul