Syntax help

[Graham]

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

 

[Don Guillett]

n=4
ncount=4
cells(n,ncount)