gravanoc
Active Member
- Joined
- Oct 20, 2015
- Messages
- 346
- Office Version
- 365
- Platform
- Windows
- Mobile
I have a range that occasionally has new columns or rows added to it, and the autofilter on this range then needs to be re-applied to cover the new material. It is not a table. My code for checking the AutoFilter will ignore that the line of code is a condition, and apply or remove it in the If statement. Unlike checking the entire sheet or a list object, there doesn't seem to be a dedicated property that I could find.
VBA Code:
If Not driveRng.AutoFilter Then
driveRng.AutoFilter
End If