Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can i print 1 page many times with diferent reference number ?
i want to print a single page where i have a number 0001 and each time i
print i want it to change in secuence like this 0002, 0003 ? thank you |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can i print 1 page many times with diferent reference number ?
Sixto,
You could use a macro... If your number is in cell A1: Sub PrintOut100Copies() For i = 1 To 100 Range("A1").Value = Range("A1").Value +1 ActiveSheet.PrintOut Next i End Sub HTH, Bernie MS Excel MVP "Sixto Valenzuela" <Sixto wrote in message ... i want to print a single page where i have a number 0001 and each time i print i want it to change in secuence like this 0002, 0003 ? thank you |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can i print 1 page many times with diferent reference number ?
Hi Sixto
Try http://www.rondebruin.nl/print.htm#number -- Regards Ron de Bruin http://www.rondebruin.nl "Sixto Valenzuela" <Sixto wrote in message ... i want to print a single page where i have a number 0001 and each time i print i want it to change in secuence like this 0002, 0003 ? thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I print noncontiguous rows on the same page? | Excel Discussion (Misc queries) | |||
My scaling is set to print 1x1 pages. But it prints 1000's of page | Excel Worksheet Functions | |||
Number of times a number is shown | Excel Worksheet Functions | |||
print selected sections on the same page | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |