Can i change a fill color in vba?

[Jon]

I am trying to color a selection i have made in vba, is there a command
to do this? Also, I would like to change the font color.

[Edwin Tam]

For example, to fill a cell with yellow:
Selection.Interior.ColorIndex = 6 'yellow

To assign a red font color:
Selection.Font.ColorIndex = 46 'red

Also, why not play with the "record macro" function? From the tools menu,
choose macro, then record macro. Set the color manually and let Excel produce
the macro for you. Then, you can easily find out the correct colorindex for
the color you need!

Regards,
Edwin Tam
[email protected]
http://www.vonixx.com



"Jon" wrote:

> I am trying to color a selection i have made in vba, is there a command
> to do this? Also, I would like to change the font color.
>
>

[Jon]

yer right, im an idiot. thanks