Excel command to Fill back color of selected Cells 1

[mstrcmtr]

To set Fore Color of Cells using the following command which is Okay

oXs.Range('A1' + ':' + 'W2').Font.Color = '-4165632' && BLUE

Q. What will be the command for Excel to fill Cells Back color of selected range

 

[GriffMG]

Something like this:

OEXCEL.CELLS(5,3).SELECT
OEXCEL.ACTIVECELL.INTERIOR.COLORINDEX = 36

Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are !good for you. ​

 

[GriffMG]

Tip:

If you don't know how automate something in Excel, record the action as a macro then read it back...

Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are !good for you. ​