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: Herman Schmerman <email@hidden>
- Date: Fri, 2 Dec 2005 19:55:23 +0100
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
tell application "Microsoft Excel" -- version 11.2 running on iBook
G4/Tiger
activate
tell document 1
repeat with i from 1 to 56
set color index of interior object of cell 1 of row i of active
sheet to i
end repeat
end tell
end tell
Herman
_______________________________________________
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