But don't use that name. It looks too much like an address (to me and excel!).

Maybe _CR1 (with the underscore)




Tom Ogilvy wrote:

As I said, Insert =Name=Define

Name: CR1
RefersTo: =Sheet1!$N$10

click the ADD button.

Change the
=Sheet1!$N$10

to the location where you want the advanced filter to copy the data to.

--
Regards,
Tom Ogilvy

"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