jordanburch
Active Member
- Joined
- Jun 10, 2016
- Messages
- 439
- Office Version
- 2016
Hey all I have the below code
Is it possible to simply filter on just the CO21army & the Left(ThisWorkbook.Worksheets("Variables").Range("a8").Value, 3) part? something I would imagine looking like this
"=CO21army" & Left(ThisWorkbook.Worksheets("Variables").Range("a8").Value, 3)* &".xlsx"
any help is appreciated!
Jordan
VBA Code:
ActiveSheet.Range("$A$1:$AF$100000").AutoFilter Field:=21, Criteria1:= _
"=CO21army" & Left(ThisWorkbook.Worksheets("Variables").Range("a8").Value, 3) & Right(ThisWorkbook.Worksheets("Variables").Range("A3").Value, 2) & ".xlsx"
Is it possible to simply filter on just the CO21army & the Left(ThisWorkbook.Worksheets("Variables").Range("a8").Value, 3) part? something I would imagine looking like this
"=CO21army" & Left(ThisWorkbook.Worksheets("Variables").Range("a8").Value, 3)* &".xlsx"
any help is appreciated!
Jordan