I have tables to run some calculations where each table is filtered by a list of variables set in sFilter(i). Not all tables have the same variable, so when running my loop, an error is thrown on tables that don't contain a variable in the list. How can I just check if the variable sFilter(i) is nothing or False when:
![]()
For i = 1 To 4 With rng .AutoFilter Field:=7, Criteria1:=sFilter(i) End With 'code Next i
Bookmarks