Hi All
I wanted to ask, if there is a way in which we can set page margin
different for different pages.
Example. Right margin for page 1 to be .75
Right margin for page 2 to be .25
Right margin for page 3 to be .75
Right margin for page 4 to be .25 and so on.
even a macro will help.

Why i need this is..i am trying to print pages one behind the other.
and same margin on all the pages mess everything.

Thanks all

<<..is [there] a way in which we can set page margin different for
different pages.

For different printed pages from the same worksheet? NO.

--
Regards,
Bill Renaud

Maybe you can record a macro when...

You change the page setup, print page 1.
change the page setup, print page 2.
change the page setup, print page 3.
change the page setup, print page 4.
etc.

I'm not sure what "and so on" means (or what I mean by etc), but you may be
able to find some tips at Ron de Bruin's site:

http://www.rondebruin.nl/print.htm


sharmashanu wrote:

Hi All
I wanted to ask, if there is a way in which we can set page margin
different for different pages.
Example. Right margin for page 1 to be .75
Right margin for page 2 to be .25
Right margin for page 3 to be .75
Right margin for page 4 to be .25 and so on.
even a macro will help.

Why i need this is..i am trying to print pages one behind the other.
and same margin on all the pages mess everything.

Thanks all

--

Dave Peterson

Will this work, if changing the page margins for each page causes the
automatic page breaks to change location after printing each page?

In other words, say you print page 1, then reduce the right margin (from
0.75"?) to 0.25". This will cause more columns of data to possibly print,
thus changing the content of page 2 and beyond, etc. How will the user know
for sure that they printed all data without duplicating anything or leaving
anything out?

--
Regards,
Bill Renaud


"Dave Peterson" wrote in message
...
Maybe you can record a macro when...

You change the page setup, print page 1.
change the page setup, print page 2.
change the page setup, print page 3.
change the page setup, print page 4.
etc.

--

Dave Peterson