danieljharvey
New Member
- Joined
- Apr 24, 2008
- Messages
- 17
Hi,
I have some code to make cell colours change incrementally, but Excel will only let me change it to the colours in the palette.
I have heard you can use Shapes instead and these are not affected by the palette. I have created "Rect1" to "Rect9", so how would I go about changing their color to an RGB value in VBA code?
Cheers
I have some code to make cell colours change incrementally, but Excel will only let me change it to the colours in the palette.
I have heard you can use Shapes instead and these are not affected by the palette. I have created "Rect1" to "Rect9", so how would I go about changing their color to an RGB value in VBA code?
Cheers