Fill a Cell with a color in VBA

palmoura · Aug 24th 2006

Hi fellows,

I have a question, can I fill a cell with a color in VBA? If is that possible, how can I do it?

Kind Rewards.

Pedro

Dave Hawley · Aug 24th 2006

Re: Fill a Cell with a color in VBA

Code

Sheet2.Range("A1:D2").Interior.ColorIndex = 5

Easiest way to get your needed ColorIndex is to simply Record a macro using the needed color.

palmoura · Aug 24th 2006

Re: Fill a Cell with a color in VBA

Thank you Dave. You're Kind and nice :music:
huges

Pedro

Participate now!