Re: changing an palette index value programmatically in Excel

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Vasant Nanavati (vasantn)
Date: 04/03/04 

Date: Fri, 2 Apr 2004 20:16:12 -0500

This is a workbook-level setting. Did you try recording a macro?

Something like:

ActiveWorkbook.Colors(3) = RGB(0, 128, 0)

should work. 

-- 
Vasant
"brad" <websta_001@hotmail.com> wrote in message
news:44e58495.0404021639.1c5b788d@posting.google.com...
> Hi all,
>
> I'm stuck, is there any way to change the color a palette index
> references from VBA.
>
> for example I want to change the color that colorindex(3) references
> from blue to green, that way all my cells that reference colorindex(3)
> change from blue to green.
>
> can I do this in VBA?
>
> thanks a lot
> b
Quantcast