Prev: VLookup in VBA Help Needed
Next: How do I create an average collum in my spreadsheet?
From: Graham on 8 Apr 2010 16:02
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
From: Don Guillett on 8 Apr 2010 16:52
n=4
ncount=4
cells(n,ncount)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"Graham" <graham(a)haughs.orangehome.co.uk> wrote in message
news:uqaiiY11KHA.5880(a)TK2MSFTNGP05.phx.gbl...
>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

 | 
Pages: 1
Prev: VLookup in VBA Help Needed
Next: How do I create an average collum in my spreadsheet?