Changing PivotTable cells in VBA

  • Thread starter Thread starter stuartmarsh
  • Start date Start date
S

stuartmarsh

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivottable refresh problem 1
Error 1004 3
Run Time Error '1004' 1
Worksheets in Loop 1
Display only selected fields in a PivotTable with VBA 2
Excel 2003 Pivot and VBA loop through each record to change cellbackground color based on conditions 0
Problem creating PivotTable from ADO recordset using VBA 0
HELP: SQL in Excel VBA 1

Back
Top