Hello,
My key strokes to record the macro are:
- Ctrl-Home
- Ctrl-F "platform"
- Alt-Downarrow "reflexion"
- Enter
The resulting VBA is:
Range("A1").Select
Cells.Find(What:="platform", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate
ActiveSheet.Range("$G$1:$P$46").AutoFilter Field:=7, Criteria1:= _
"=REFLEXION", Operator:=xlOr, Criteria2:="=REFLEXION LK"
I want the VAB to do the autofilter on the column that it found the word "platform" in row 1, not on the 7th column from the left (Field:=7).
Thanks!
My key strokes to record the macro are:
- Ctrl-Home
- Ctrl-F "platform"
- Alt-Downarrow "reflexion"
- Enter
The resulting VBA is:
Range("A1").Select
Cells.Find(What:="platform", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate
ActiveSheet.Range("$G$1:$P$46").AutoFilter Field:=7, Criteria1:= _
"=REFLEXION", Operator:=xlOr, Criteria2:="=REFLEXION LK"
I want the VAB to do the autofilter on the column that it found the word "platform" in row 1, not on the 7th column from the left (Field:=7).
Thanks!