Thread: printing
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
ynissel ynissel is offline
external usenet poster
 
Posts: 14
Default printing

thanks - Ill try it now.

"Dave Peterson" wrote:

You can edit your recorded code to just the lines that you need. Just keep the
line that changes orientation, for example.

ynissel wrote:

I tried but it added like 15 lines of code and takes the marco an extra 30-40
seconds
to run and the screen keeps flashing. Is there a 1 liner I can add?

"Dave Peterson" wrote:

Record a macro when you make your changes. You'll see the code.

ynissel wrote:

how do I set a macro to change the orientation to landscape and seperately to
portrait?
Thanks

--

Dave Peterson


--

Dave Peterson