Re: Office 2011: Excel Question
Re: Office 2011: Excel Question
- Subject: Re: Office 2011: Excel Question
- From: Paul Berkowitz <email@hidden>
- Date: Sun, 22 Jan 2012 11:47:17 -0800
- Thread-topic: Office 2011: Excel Question
Title: Re: Office 2011: Excel Question
On 1/22/12 2:13 AM, "Christopher Stone" <email@hidden> wrote:
It looks like I've found the answer to my question thanks to Ben Waldie and MacTech:
tell application "Microsoft Excel"
tell worksheet "Sheet1" of active workbook
set value of range "A1:C2" to {{"a", "b", "c"}, {"d", "e", "f"}}
end tell
end tell
But if someone has something useful to add I'm all ears.
Nothing to add - that's how to do it. If you have any non-contiguous ranges to fill, it's simplest just to do each one separately like that.
(I suppose you could save a few characters of typing by just telling 'active sheet' if it's the one open rather than specifying which sheet in the active workbook, but that's just minor stuff. Sometimes you might need indeed to specify one deeper in, or whatever.)
--
Paul Berkowitz
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden