Name Reference problem

[jomili]

I've got a macro manipulating a pivot table, and I'm having trouble selecting one part of my data range. The errant line from my macro is below.

Please Login or Register  to view this content.

The problem is that the title is formatted like this:

Please Login or Register  to view this content.

, and I don't know how to put that into my code. Any help is highly appreciated.

[jomili]

Okay, I solved that one on my own. Here's my solution:

Please Login or Register  to view this content.

I got this by using the Macro Recorder (which I thought I'd already done, but obviously not). That'll teach me.

Thanks anyway!