View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
EddySon EddySon is offline
external usenet poster
 
Posts: 2
Default Printing numbers in Excel. Macro needed.

I would like to use a macro in Excel to print a number in the top
right hand corner onto blank sheets of A4 paper.


In Cell M1 I would like to have a text string e.g. Order Number
In Cell M2 have the start number
In Cell M3 have the number of copies before the number increments (e.g.
print 4 sheets with 100 then increment to 101
and print another 4 sheets etc.)
In Cell M4 have the total number of "batches" to print. e.g. 10 ( to give 10
* the value in M3)
All help appreciated
Thanks Ted