Thread: Printing
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jdawg jdawg is offline
external usenet poster
 
Posts: 5
Default Printing

Is there a way I can create a Macro attached to a button, so when a
user clicks the button, it will automatically print the following
ranges in order. Any help would be greatly appreciated. I am sure
there is a simple code but I am having trouble figuring it out. Thanks

Sheet 1 - Range A1:H42
Sheet 2 - Range A1:H40
Sheet 3 - Range A1:H39

Sheet 1 - Range I1:P42
Sheet 2 - Range I1:P40
Sheet 3 - Range I1:P39