ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Changing PivotTable cells in VBA (https://www.excelbanter.com/excel-programming/369383-changing-pivottable-cells-vba.html)

stuartmarsh[_2_]

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


stuartmarsh[_3_]

Changing PivotTable cells in VBA
 

Can anyone help me with this

--
stuartmars
-----------------------------------------------------------------------
stuartmarsh's Profile: http://www.excelforum.com/member.php...fo&userid=2214
View this thread: http://www.excelforum.com/showthread.php?threadid=56829



All times are GMT +1. The time now is 02:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com