backcolor Property to Pivot Cell Object

M

marco

Hi Everybody,

I have an iteraction to get the pivot cells for my first column using
aggregate function and need to set backcolor cell with diferent colors but
the pivotcell object doesn't have backcolor property to do this.

How i can use this property to colorize my pivottable? DO you have any
code that can help me?

Note: I'm coding inside html file using vbscript and here is my iteraction
code for this:

Dim rm
Dim cm
Dim cell
For Each rm In data.RowMembers("VIS").ChildMembers
Set cm = data.ColumnMembers("Acum").ChildMembers("LCC")
Set cell = data.Cells(rm, cm).Aggregates(0)
MsgBox ("Value = " & cell.Value)
Next

Thanks in Advanced!
Ace73
 

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

Help on backcolor property... 0
backcolor to PivotAggregate Cell 5
Pivot Table Cells Coloring 3
Retrieving pivot items for pivot table value cells without using PivotCell 0
Cell Trigger To Change Pivot Table 2
VB code to update existing Pivot Table 2

Top