nniedzielski
Well-known Member
- Joined
- Jan 8, 2016
- Messages
- 598
- Office Version
- 2019
- Platform
- Windows
I am running this code, but when its done the worksheet yc is still left filtered, and i have to turn it off, im currently running this:
i tried to just add an autofilter by doing:
but that didnt work
VBA Code:
With yc
.Range("A1:F1").AutoFilter Field:=6, Criteria1:="Red Tag"
.AutoFilter.Range.Copy Sheets("Red Tag").Range("A1")
End With
With Sheets("Red Tag").UsedRange.Borders
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
End With
Sheets("Red Tag").UsedRange.EntireColumn.AutoFit
i tried to just add an autofilter by doing:
Code:
.autofilter
but that didnt work