VBA code for not filling in color

[haffy311]

Is there VBA color to change ".Fill.ForeColor.SchemeColor =" into NO FILL? In other words, keeping the existing Foreground color prior to the macro being activated.

I'm in a chart.

 

[Tom Urtis]

Cannot tell what context you are asking the question in. Is this about cells and you don't want them to be colored by way of their interior color property? If so you can say using A1 for an example...

Range("A1").interior.ColorIndex = 0

But maybe you mean something else and maybe not even with cells, and maybe there's conditonal formatting involved somehow...

Edit, just saw that part about bing in a chart...is it the plot area opr the chart area or something else...just need more info about what you want to manipulate.