Print range question

  • Thread starter Thread starter test
  • Start date Start date
T

test

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?
 
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
 
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
 
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
Click to expand...
Thanks a lot!!! :-)
 
Back
Top