• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Office 2011: Excel Question
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

References: 
 >Re: Office 2011: Excel Question (From: Christopher Stone <email@hidden>)

  • Prev by Date: Re: Insert Text Here
  • Next by Date: 'Show Desktop' (Mission Control) using AppleSript?
  • Previous by thread: Re: Office 2011: Excel Question
  • Next by thread: 'Show Desktop' (Mission Control) using AppleSript?
  • Index(es):
    • Date
    • Thread