Change Cell Color in Excel Spreadsheet 2

[chadau]

How do I change the color of a Cell in an Excel Spreadsheet using the Excel Worksheet class from a VB app?

 

[xlbo]

Bit of a general question but lets say you have an excel object defined as ExcelApp

With ExcelApp.workbooks("Workbookname&quot.worksheets("WorksheetName&quot
.range("A1&quot.interior.colorindex = 3
end with

will change the background colour of cell A1 to red

Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde

 

[chadau]

Thanks

 

[xlbo]

Chadau - I'm not asking for a star here but I've had a look at your profile and you have made 32 posts and have not awarded any stars - and I can't believe that you have not received helpful information in at least one of those posts. Here at Tek-Tips, the accepted way of saying thanks is to award a star. This also helps those users who use the search facility, to home in on those posts that have been deemed "Helpful or Expert"
To award a star, simply click on the "Mark this post as a helpful / expert post" on the appropriate posting

Please accept this post as a bit of information for you and not a request for a star.

Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde

 

[chadau]

Truth is buddy that I have received a lot of help from Tech Tips in general, and until now I wasn't really aware of the star system.

 

[xlbo]

No probs - I figured as much - hence the post.
:0)

Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde