How do I Change Font size and color of a cell ?

[snehakevin]

I am creating an excel sheet from VB6.
This is working fine. I need to change the font size and color of few cells, say sheet heading and column heading...
can anyone help..

 

[ADoozer]

for cell color use something like :-

myExcelWorksheet.Range("E9&quot.Interior.Color = vbBlue

and for font size something like :-

myExcelWorksheet.Range("H15&quot.Font.Size = 32

good luck!

If somethings hard to do, its not worth doing - Homer Simpson
------------------------------------------------------------------------

http://www.climateprediction.net/index.php

come on... get involved!
To get the best response to a question, please check out FAQ222-2244 first
A General Guide To Excel in VB FAQ222-3383

 

[snehakevin]

Thank you very much...