Filter desired columns

[elsg]

Hi.
I have data in columns "A: K"
How do I filter out only the "C: K"?
Don't work!

Sub TestFilter()
    Sheets("Plan1").Range("B11:J3000").ClearContents
   With Plan1
        .AutoFilterMode = False
        .Columns("A:B").EntireColumn.Hide = True
        .Range("C1:K1").AutoFilter Field:=9, Criteria1:="Presente"
        .Range("C1:K1").CurrentRegion.Copy Destination:=Plan4.Range("B10")
        .Range("C1:K1").AutoFilter
   End With
End Sub

thank you!

 

[FDibbins]

If you mean that when you filter only C:K, and rows 4:7, for instance, are hidden, that they remain visible in A:B, this is not possible. A filter, when applied, hides an entire row, not just part of it (ie not just rows in certain columns)

 

[elsg]

Hi.
I want to filter and copy only the columns "C: K"


how I do it using my code?

 

[elsg]

Hi.

Any idea?

Thks

 

[elsg]

Hi.

can anyone help me?

Thank you!!!

 

[elsg]

Hi

anyone have any idea?

Is that possible?

Thanks!