Using Variable in RANGE
 

In a macro I calculate the number of rows and assign it
to 'TOTACS'. I then try and use TOTACS in a Range
statement but it will not let me. How do I go about doing
this? Below is my code:

totacs = dmclastrow + authlastrow

Range("A2").Select

Range("A1:"totacs).AdvancedFilter
Action:=xlFilterCopy, CopyToRange:= _
Columns("G:H"), Unique:=True

Using Variable in RANGE
 

Hi
see your other post

-----Original Message-----
In a macro I calculate the number of rows and assign it
to 'TOTACS'. I then try and use TOTACS in a Range
statement but it will not let me. How do I go about
doing
this? Below is my code:

totacs = dmclastrow + authlastrow

Range("A2").Select

Range("A1:"totacs).AdvancedFilter
Action:=xlFilterCopy, CopyToRange:= _
Columns("G:H"), Unique:=True
.