RE: Excel 2004 - How to set fill color of cells?
RE: Excel 2004 - How to set fill color of cells?
- Subject: RE: Excel 2004 - How to set fill color of cells?
- From: "Scott Babcock" <email@hidden>
- Date: Fri, 2 Dec 2005 11:01:36 -0800
- Thread-topic: Excel 2004 - How to set fill color of cells?
Try this:
tell application "Microsoft Excel"
set color index of interior object of range "A1" of active sheet to
3
end tell
> Date: Fri, 02 Dec 2005 19:20:38 +0100
> From: Richard R ? nnb ? ck <email@hidden>
> Subject: Excel 2004 - How to set fill color of cells?
> To: AppleScript <email@hidden>
> Message-ID: <BFB64F06.1A50E%email@hidden>
> Content-Type: text/plain; charset="US-ASCII"
>
> I know this must be really simple, but I have spent several hours
trying
> to
> figure out how to set the cell color in Excel 2004 and the closest I
get
> is:
>
> tell application "Microsoft Excel"
> tell document 1
> set color index of interior object of style object of cell 1
of
> row
> 1 of active sheet to 3
> end tell
> end tell
>
>
>
> Which for some reason, that is totally beyond me, colorizes of all
cells.
>
> Can someone please tell me what I am doing wrong?
>
>
> // Richard
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden