Changing Font in VBA

[Henry]

Her's what I have: Sheets("APs").Range("2:2,5:5,10:10").Font.Color = 3

What do I need to change to to make the Font appear white?

Is there a site that shows what numbers are what colors?

Thanks

 

[Joe4]

If you want to find out what code a certain color is, turn on the macro recorder, and manually change some text to the color you want. Then turn off the macro recorder and view the code you recorded. This will tell you what the code is.

 

[Cbrine]

Try Colorindex instead of just color.

 

[Legacy 21301]

....... what numbers are what colors?

It's in the VBE Help file.