filter columns A:C only

[SQUIDD]

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.

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

 

[Sektor]

AutoFilter hide the entire row - you can't hide some cells.

 

[SQUIDD]

Hi Sektor

I thought as much.

ok, I will write a code to copy the range on the right to an new sheet.
then return, filter the data, copy filtered range to the new sheet etc

thanks for looking

Dave