Hi Scott

Use the Format function

.Range("A1").Value = "LR-01-" & Format(CopieNumber, "000000")



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Scott Senffner" wrote in message
...
Ron,

I am using this one. I am now trying to format the cell with LR-01-000000

Thanks for all of your help.

Scott Senffner

"Ron de Bruin" wrote:

hi Scott

See this page for a example
http://www.rondebruin.nl/print.htm#same

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Scott Senffner" wrote in message
...
I am looking for help in configuring a printed form. I have a basic form in
excel that has a number in the upper right hand corner that needs to change
when I print multiple copies. Say the number is LR-01-000025. I want to go
to Print, copies, 100.

I want the number to change from LR-01-000025 to LR-01-000026, LR-01-000027
... to LR-02-000125.

Your help would be greatly appreciated.

Scott Senffner