I'm trying to have VBA do an auto-filter refresh whenever I open my workbook file. I'm encountering an error whenever it opens up though. Any ideas?
Edit: I just want it to refresh the entire auto-filter table which is from columns A to G with rows 4 to 300 (for now)
debug_help.png
Last edited by huyza_0100; 09-15-2017 at 05:24 PM.
try
With WSFound2
.AutoFilterMode = False
. Range("A1:G1").AutoFilter
. Range("A1:G1").AutoFilter Field:=1 Criteria1:="<>"
End With
This gave me a syntax error with . Range("A1:G1").AutoFilter Field:=1 Criteria1:="<>" highlighted in red
Please Login or Register to view this content.
Sorry, I forgot the comma between Field:=1, Criteria1="<>"
Please Login or Register to view this content.
Thanks!! Definitely helped!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks