Background color

D

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.
 
J

JMay

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