View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
[email protected] ickook@optusnet.com.au is offline
external usenet poster
 
Posts: 3
Default print 4 pages on 1 page using vba

On Mar 10, 11:56*pm, Dave Peterson wrote:
If you can do it manually via the page setup, how about recording a macro while
you do it?

wrote:

Hi
I am trying to print 4 pages on 1 page. I know you can do this through
the page setup,and it works well.
But I am after a way to do it with vba code, not having any success.
Any help would be much appericated.
Regards
mick


--

Dave Peterson


Thanks for the reply Dave. I have tried recording the macro via page
setup, but when I look at the code there is no reference to changing
the number of pages.
Regards
Mick