I would value help with below. The first part is what I want to do and
what is there works fine. However because of the procedure where
locations are variable eg Cells (n, ccount) etc I need to use the syntax
on the second procedure and I am unsure of how to enter this and would
appreciate any guidance.

Graham

Range("AF1:AG10").AdvancedFilter Action:=xlFilterCopy,
CopyToRange:=Range("AF14:AG14"), Unique:=True

Range(cells(1,32),cells(9,33)).AdvancedFilter Action:=xlFilterCopy,
CopyToRange:=Range(Cells(13,32),cells(13,33)), Unique:=True