:banghead:Morning, I'm trying to find a way to filter a worksheet with one value on two different columns, but failing!
The below code works a treat to filter one column on the correct value
Worksheets("Update").Range("R1").AutoFilter _
field:=18, _...