View Single Post
  #20   Report Post  
Posted to microsoft.public.excel.programming
Opal Opal is offline
external usenet poster
 
Posts: 59
Default Pivot Table - change page field help

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....?