Print range question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

test@testnospam.nl - 05 Jan 2008 11:46 GMT

I've made a spreadsheet with several tabs.
In this sheet i've selected a certain print range so only the
information i need gets printed.
But when i try to print the sheet, or on the print preview everything
on the sheet gets printed..

I thought that only things inside the print range (visible on the
sheet with a thin line), would be printed...

Is there a way that i can define wich range only can be printed
besides the print range option?
I have made this sheet with Excel2007 and converted it to Excel2003.
Is there something gone wrong with this conversion?

Reply to this Message

Bernard Liengme - 05 Jan 2008 13:43 GMT

I cannot reproduce this. In Excel2007 I set a print area; saved the book as
an XLS file; opened it in Xl2003 and all was well
Suggest you try again and let us know the result
best wishes

Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

> I've made a spreadsheet with several tabs.
> In this sheet i've selected a certain print range so only the
[quoted text clipped - 9 lines]
> I have made this sheet with Excel2007 and converted it to Excel2003.
> Is there something gone wrong with this conversion?

Reply to this Message

JP - 05 Jan 2008 13:44 GMT

You have to set the print area. Select the section you want to print, then

a. File>Print Area>Set Print Area, or
b. use ActiveSheet.PageSetup.PrintArea = "$A$1:$A$10" in your code.

HTH,
JP

Reply to this Message

test@testnospam.nl - 05 Jan 2008 21:37 GMT

>You have to set the print area. Select the section you want to print, then
>
[quoted text clipped - 3 lines]
>HTH,
>JP

Thanks a lot!!! :-)

Reply to this Message