RE: Filling a cell in Excel
RE: Filling a cell in Excel
- Subject: RE: Filling a cell in Excel
- From: "Scott Babcock" <email@hidden>
- Date: Fri, 4 Jun 2004 09:52:46 -0700
- Thread-topic: Filling a cell in Excel
Excel v.X supports this type of fill operation, too. The thing that's
missing is the 'get international' event. You can use the 'Evaluate"
event to get that, though:
tell application "Microsoft Excel"
set listSep to Evaluate "INDEX(GET.WORKSPACE(37),5))"
set Value of Range ("A1:C3" & listSep & "D4:D6") to {{"A1", "B1",
"C1"}, {"A2", "B2", "C2"}, {"A3", "B3", "C3"}}
end tell
- Scott
-----Original Message-----
From: Bill [
mailto:email@hidden]
Sent: Wednesday, June 02, 2004 10:59 PM
To: email@hidden
Cc: Scott Babcock
Subject: Re: Filling a cell in Excel
>
>
You can even fill multiple noncontiguous ranges from one list:
>
>
tell application "Microsoft Excel"
>
set listSep to get international entry index list separator
>
set value of range ("A1:C3" & listSep & "D4:D6") to {,
>
{"A1", "B1", "C1"}, ,
>
{"A2", "B2", "C2"}, ,
>
{"A3", "B3", "C3"}}
>
end tell
Scott,
Can we do the same task in Excel v.x?
TIA
bill
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.