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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VB.net and excel spreadsheet 4
vb.net forms error 1
Displaying zeros in cells 2
DataGridView Changing Cell Color 1
vb.net classmanager 1
Excel In VB.net 2
Excel range object into VB.net 2
Exceptions, VB.NET and INTEL Fortran 3

Back
Top