Syntax help
 

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

Syntax help
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Graham" wrote in message
...
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