I am trying to run a User Form I just created and keep getting stuck on this error in my Advanced Filter. I have confirmed the data and range information but can't get past this. The exact same code runs fine in a different user form. Any ideas for a newbie vba user?
Rich (BB code):
Sub AdvFilter() On Error GoTo errHandler: With Sheet2 .Range("B8").CurrentRegion.AdvancedFilter Action:=xlFilterCopy, _ CriteriaRange:=Sheet2.Range("K3:N4"), CopyToRange:=Sheet2.Range("U8:AK8"), Unique:=False End With On Error GoTo 0 Exit Sub errHandler:: MsgBox "An Error has Occurred. Please notify the administrator" End Sub
Last edited by a moderator: