Even if you qualified it completely:

thisworkbook.worksheets("full Record").range("pivotData").advancedfilter _
action:=....

(I left thisworkbook off by mistake, sorry.)

PivotData is on worksheet "full record", right?

LS wrote:

Thanks for the suggestion Dave, unfortunately I still get an error
at that point, caused by spaces in the filename.

LS

Dave Peterson wrote in message ...
I think I'd just use:

worksheets("full Record").range("pivotData").advancedfilter _
action:=....

But I'd fully qualify that copytorange, too:

worksheets("full Record").range("pivotData").advancedfilter _
action:=xlFilterCopy, _
CriteriaRange:=Sheets("FULL RECORD").Range("L2:M3"), _
CopyToRange:=worksheets("filtered data").Range("A7:BQ7"), Unique:=False



--

Dave Peterson