Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
from Range variable | Excel Discussion (Misc queries) | |||
variable range | Excel Programming | |||
variable range: l just can't get there! | Excel Programming | |||
Variable Range | Excel Programming | |||
Problem trying to us a range variable as an array variable | Excel Programming |