Copying data & creating new worksheets - error
Never mind!
Dave Peterson wrote:
CR1 is an address. You're putting the unique list on that ws1 worksheet in cell
CR1.
But I didn't see where you set ws1 variable to any worksheet.
Set ws1 = activesheet
or
set ws1 = worksheets("sheet99") '<--change to what you want.
This set statement has to be before your
Set rng = ws1.Range("A1", ("A" & NoAccounts)).Product '<<< Change
line.
Jen wrote:
Tom,
I tried setting the worksheet both ways that you suggested. It's still
getting caught up on this, with the same variable not defined error
message:
rng.Columns(1).AdvancedFilter _
Action:=xlFilterCopy, _
CopyToRange:=.Range("CR1"), Unique:=True
I haven't defined the range CR1, how do I go about doing that?
Thanks,
Jennifer
--
Dave Peterson
--
Dave Peterson
|