giving cells a nice color

[Bart van den Burg]

Hi

how can I, in VBA, give a color to cells, text in cells, and make texts in
cells bold?

thanks

 

[Bart van den Burg]

Hi
have a look at the following properties:
range.inerior.colorindex
range.font.colorindex
range.bold

what values are valid for colorindex?

 

[Frank Kabel]

Hi
have a look at the following properties:
range.inerior.colorindex
range.font.colorindex
range.bold

 

[Frank Kabel]

Hi
see:
http://www.mvps.org/dmcritchie/excel/colors.htm

 

[Bart van den Burg]

Hi
see:
http://www.mvps.org/dmcritchie/excel/colors.htm

Thanks a lot!