| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying data between worksheets | Excel Discussion (Misc queries) | |||
| I get an error message while copying worksheets between workbooks | Excel Discussion (Misc queries) | |||
| Copying data across worksheets | Excel Discussion (Misc queries) | |||
| Copying data across different worksheets | Excel Discussion (Misc queries) | |||
| Macro programming for Creating New Sheets and Copying Data | Excel Programming | |||
Threaded Mode
