Hi,
What's wrong with my syntax here:
The highlighted bit is the problem.
Can anyone advise?
Thanks,
Matty
What's wrong with my syntax here:
Code:
.Range("I1:I" & LR).AdvancedFilter Action:=xlFilterInPlace, Unique:=True
.Range("I2:I" & LR).Copy Sheet2.Range("E5")[COLOR=#ff0000].PasteSpecial Paste:=xlPasteValues
[/COLOR]
Can anyone advise?
Thanks,
Matty