Changing Spreadsheet Cell Attributes In VB.Net

  • Thread starter Thread starter Atley
  • Start date Start date
A

Atley

I have been creating spreadsheets in VB.net 2003 and i can get most
everythign perfect, except changing the color of the fonts and the cells, i
keep getting exception errors when i try to use:
xlRange.font.background = color.lightgray

I can't seem to find any documentation on this, does anyone know what is
going on?


Thanks for the help.
 
Open Excel and start recording a macro. Change the font/color as you want it
to be done by your app. Stop recording the macro and go look at the code
that Excel has generated for the macro.

This has helped me several times when I have wanted to figure out what code
to use to something in VBA.

Vikas
 
Back
Top