View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
billabong billabong is offline
external usenet poster
 
Posts: 14
Default VB code for printing one page at a time

I have created a small label making program (7 labels per page)
But if I print 8 or more labels I have to print twice- one for 7 and
the remainder.

I would like to create 2 command buttons, one to print pg 1 and the
other pg

What would the code be for this action

Ran a macro and tried working backwards but no luck

Many Thanks