View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
stuartmarsh[_2_] stuartmarsh[_2_] is offline
external usenet poster
 
Posts: 1
Default Changing PivotTable cells in VBA


Hi everyone,
I have two questions:

- Is it possible to loop through the PivotTable and put comments
against individual cells?
- Is it possible to loop through a PivotTable and change a PivotCell
value to something else?


If you can provide some code examples that would be great :) .

Cheers,
Stu


--
stuartmarsh
------------------------------------------------------------------------
stuartmarsh's Profile: http://www.excelforum.com/member.php...o&userid=22142
View this thread: http://www.excelforum.com/showthread...hreadid=568297