Background color

[Dave Griffiths]

I am creating a sheet where VBA creates new cells, I need to color the
cell background, I just cannot seem to find anything that looks remotely
like a fill or background function.

I have been trying in the area of

Range("A1").

Help would be very much appreciated.

Thanks.

 

[JMay]

Range("A1").Interior.ColorIndex = 6 will produce the yellow background
color in A1

 

[Dave Griffiths]

Thanks

Range("A1").Interior.ColorIndex = 6 will produce the yellow background
color in A1