Re: Filling a cell in Excel
Re: Filling a cell in Excel
- Subject: Re: Filling a cell in Excel
- From: David Wignall <email@hidden>
- Date: Fri, 04 Jun 2004 10:25:17 +1200
on 4/06/2004 4:51 AM, David Weiss at email@hidden wrote:
>
On Jun 2, 2004, at 10:58 PM, Bill wrote:
<missing attribution but probably Scott Babcock at email@hidden on
3/06/2004 11:11 AM>
>
>> 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?
>
Nope. Only in Excel 2004.
You can, only without all the lovely internationalisation:
set Value of Range ("A1:C3 ,D4:D6") to {{"A1", "B1", "C1"}, {"A2", "B2",
"C2"}, {"A3", "B3", "C3"}} -- 1 line, tested
--
Dave
_______________________________________________
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.