Hi all,
I have a program in Excel that builds a table in PowerPoint and fills this with Excel data.
The code:
Set Data = newPowerPoint.ActivePresentation.Slides(2).Shapes.AddTable(12, 17)
With Data
ColoredColumns = RGB(243, 200, 167)
.Table.cell(1, 2).Shape.Fill.ForeColor.RGB = ColoredColumns
End With
As you can see, I'm able to color the cell the way I want to. Problem is, I need to color 92 cells with the same color and that is taking to much space if I do this cell by cell.
Is it possible to color an entire column? If yes, how?
Thanks!
Ganesh