Hi.
I have data in columns "A: K"
How do I filter out only the "C: K"?
Don't work!
thank you!
I have data in columns "A: K"
How do I filter out only the "C: K"?
Don't work!
Code:
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!