Excel VBA BackColor

[Ascentient]

Is there a way to use the Selection method to change the BackColor for a selection of cells?

    Range("k9:p38").Select
    Selection.BackColor = &H80000005

I thought the above might work, but I get the following error: Run-time error '438' Object does not support this property or method.

Ascent

 

[RoyVidar]

Forum707 is for Office VBA, this is Access VBA, but I don't think the excel range object has a backcolor property, I'd assume something like

[tt] Selection.interior.color = &H80000005[/tt]

but it should be enough with

[tt] Range("k938").interior.color = &H80000005[/tt]

I think?

Roy-Vidar

 

[Ascentient]

Although I supplied the wrong hex code, this will do the trick.

Thanks Roy!

Ascent