Hi!
I am new in vba. I want below code to work automatically but it don't until I click on any cell in the same sheet. Kindly help me solving this issue.
Kindly also suggest if i can transfer this code to commandbutton click event.
Thanks in advance,
Asghar
Private Sub Worksheet_SelectionChange(ByVal Target As Range) ActiveSheet.Range("$A$1:$BT$1387").AutoFilter Field:=4, Criteria1:= _ "=*" & Range("BY1").Value & "*", Operator:=xlAnd End Sub
Bookmarks