Thread: What are the cells in a Pivot Table range?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Darrell Wesley[_2_] Darrell Wesley[_2_] is offline
external usenet poster
  
Posts: 10
Default What are the cells in a Pivot Table range?
I have a pivot table where the field button for the data is located in cell
A3. I noticed that when Excel automatically creates a chart along with the
table it says the location is at Range("A3").

How can I through VB find out the cells that are contained in that range so
that I can set the format correctly to either "currency" or "percent" rather
than "general"?
Reply With QuoteReply With Quote