Greetings, Gurus.
I am filtering to all columns that have the word "Show" in column 35. In my VBA I need an error trap to exit my VBA if the filter comes back empty. Below is an example of what I attempted, and it did not work because if I offset 1 from A5 it goes to A6 even if the row is hidden.
Sheets("SPL Pricing by P5").Select
ActiveSheet.Range("$A$5:$AI$396").AutoFilter Field:=35, Criteria1:="Show"
Range("A5").Offset(1, 0).Select
If ActiveCell = 0 Then GoTo NOCHANGE
Thanks in advance for any help you can offer.
Hutch
Bookmarks