SQUIDD
Well-known Member
- Joined
- Jan 2, 2009
- Messages
- 2,104
- Office Version
- 2019
- 2016
- Platform
- Windows
Hello All
I am wondering if it is possible to filter just column A:C starting at row 2.
But here's the tricky part.
I want the data in column D:K to remain so the filter does not remove it.
Possible?
Hope it makes sense, if not let me know.
Below is my code so far, but this removes the data I have stored in columns D:K that I wish to remain.
Dave
I am wondering if it is possible to filter just column A:C starting at row 2.
But here's the tricky part.
I want the data in column D:K to remain so the filter does not remove it.
Possible?
Hope it makes sense, if not let me know.
Below is my code so far, but this removes the data I have stored in columns D:K that I wish to remain.
Code:
Sub FILTER()
A = Month(Date)
ActiveSheet.Range("$A$2:$C$367").AutoFilter Field:=1, Operator:= _
xlFilterValues, Criteria2:=Array(A, "1/31/2017")
ActiveWindow.SelectedSheets.PrintOut Copies:=2, Collate:=True, _
IgnorePrintAreas:=False
ActiveSheet.Range("$A$2:$C$367").AutoFilter Field:=1
End Sub
Dave