jordanburch
Active Member
- Joined
- Jun 10, 2016
- Messages
- 440
- Office Version
- 2016
Hey all! Happy Friday!
I have the below. IT basically checks for a filter and if there is one it takes it away. Its not working though on some new code, it seems to work fine on other code. The error message is there is no filter on the currently selected sheet fyi
compile error unvalid or unqualified reference
any ideas?
Jordan
If .AutoFilterMode Then
If .FilterMode Then
.ShowAllData
End If
Else
If .FilterMode Then
.ShowAllData
End If
End If
End With
I have the below. IT basically checks for a filter and if there is one it takes it away. Its not working though on some new code, it seems to work fine on other code. The error message is there is no filter on the currently selected sheet fyi
compile error unvalid or unqualified reference
any ideas?
Jordan
If .AutoFilterMode Then
If .FilterMode Then
.ShowAllData
End If
Else
If .FilterMode Then
.ShowAllData
End If
End If
End With