Function .Interior.Color

[AT--o]

Application.ThisCell.Font.Color = RGB(255, 0, 0) 'WORKS.

Application.ThisCell.Interior.Color = RGB(255, 0, 0) 'DOESNT WORK.

Can the Interior of a cell be changed in a Function?

 

[Jonmo1]

Welcome to the board...

Yes...and No..

if the Function is called from another macro/sub...Then YES.
if the Function is called from a Cell Formula...Then No.

Hope that helps.

 

[AT--o]

I was afraid of that.

 

[Scott Huish]

Why not just use a sub?

Sub Red()
Activecell.Interior.Color=vbRed
End Sub

and assign a shortcut key to it, if you don't want to use the color palette.