Posted to microsoft.public.excel.programming

Jim[_31_]

external usenet poster

Posts: 13

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Variable Range	James C.	Excel Discussion (Misc queries)	3	April 2nd 09 12:41 AM
how to specify a range that is variable.	Mal[_2_]	Excel Worksheet Functions	4	April 9th 08 03:39 PM
Variable in a range.	Chris	Excel Programming	2	December 3rd 03 12:54 PM
variable range: l just can't get there!	ste mac	Excel Programming	2	October 27th 03 06:43 PM
Problem trying to us a range variable as an array variable	TBA[_2_]	Excel Programming	4	September 27th 03 02:56 PM

All times are GMT +1. The time now is 09:39 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us