View Single Post
  #21   Report Post  
Posted to microsoft.public.excel.programming
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default 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....?