Well, I read your response about it being a named range and thought I missed it
(and didn't go back to review).

Well, it sounds like the OP may have something that is close to working <vbg.

Tom Ogilvy wrote:

Good catch. I got headed off in the wrong direction with this line thinking
the OP had a defined name/range:

This is part of a much longer module that defined the range previously.

I got target fixation - flew into the ground <g
Of course that is just a cell reference.

--
Regards,
Tom Ogilvy

"Dave Peterson" wrote in message
...
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

--

Dave Peterson