Pivot Table - change page field help
Hi
This thread has got pretty long now.
Perhaps it would be easier if you mailed me a copy of your workbook, and I
will set it up for you.
To mail direct, send to
roger at technology4u dot co dot uk
Change the at and dots to make valid email address
--
Regards
Roger Govier
"Opal" wrote in message
...
Thank you, Roger...so this would run in a module or
on the FSChart1 sheet? The A1 cell is in the FSChart1 sheet
so would the lines:
.CurrentPage = newvalue
Exit For
Else
.CurrentPage = "(All)"
Still work as FSChart1 is not the current page....?
|