Re: M$ XL Area selecting and printing
Re: M$ XL Area selecting and printing
- Subject: Re: M$ XL Area selecting and printing
- From: David Wignall <email@hidden>
- Date: Thu, 08 May 2003 22:26:39 +1200
on 8/5/2003 7:43 PM, Bernard Azancot at email@hidden wrote:
>
This is my first M$ XL AS.
>
>
I would like to select an area and print it.
>
>
>
For the selection, I have tried:
>
---
>
Select Range ("A1":"H44")
>
---
>
but I had an error message (numeric index ?).
Too many " marks. This works:
Select Range ("A1:H44")
>
Is it necessary to select a sheet path if you are already "in it",
>
launching the script using AS menu ?
Many things, including ranges, assume ActiveSheet unless otherwise
specified. Quick testing indicates this is still true when run from Script
Menu
>
Then, what would be is the good way to select this sheet ?
You can refer to any sheet either by name
Sheet("Secondary Data")
or by index number
Sheet(2)
>
For the printing, is "print selection" possible ?
Sure is:
Print Selection
Alternatively you could set the print area:
set PrintArea of PageSetup of ActiveSheet to "A1:H44"
--
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.