How could i use something like
to check if the next visible cell (not next cell down) while using autofilter is blank?
Code:
ActiveCell.Offset(1, 0).Value = ""
Code:
ActiveSheet.Range("$K$2:$DF$199").AutoFilter Field:=61, Criteria1:="<>"
If ActiveCell.Offset(1, 0).Value = "" Then
Else
Application.GoTo reference:="Ravenclaw"
Call TomRiddle
End If