Lists

Open Menu Close Menu

Terms and Conditions
Lists hosted on this site
Email the Postmaster
Tips for posting to public mailing lists

Re: Excel print area

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Excel print area

Subject: Re: Excel print area
From: "Willard L. McMunn" <email@hidden>
Date: Tue, 07 May 2013 08:31:50 -0400

Try this:

tell application "Microsoft Excel"

tell active workbook

tell active sheet

set rangeToName to range "A2:E23"

--or

set rangeToName to used range

set name of rangeToName to "Print_Area"

end tell

On May 7, 2013, at 7:48 AM, email@hidden wrote:

I using Excel 2011 and would like to set the print area using applescript. Does anyone have a clue if this ca be done? Any advice or guidance is greatly appreciated.

Thanks in advance

----------------------------------------
Happy Automation,
Larry McMunn, President

McMunn Associates, Inc. • Collingswood, NJ • Seminole, FL
(856) 393-4756 or Skype: wlarrymcmunn

"If you look backward in this business, you'll be crushed. You have to look forward" —Steve Jobs, 1955-2011

 _______________________________________________
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

Prev by Date: Excel print area
Next by Date: Re: uneditable [OT]
Previous by thread: Re: Rename Folder without it moving
Next by thread: AUTO: Allyn Martin is out of office.
Index(es):
- Date
- Thread