Print range question

[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?

 

[Bernard Liengme]

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

 

[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

 

[test]

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

Thanks a lot!!!