printing een special number

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Marc.paternotte - 10 Jun 2006 20:07 GMT

Hee, i have a problem.
I like to print a file that has a number that changes every time that i
print the file.
How kan i make this posible.

P.s. the file is a list.
Every menber in the company can use this page to ask materials.
To order this materials en to now withs material for who, i need every time
a different (unique) number.

Thansk in advange

Reply to this Message

Paul B - 11 Jun 2006 21:03 GMT

Marc,
A simple way would be to use something like this, in the before print event.
Sheets("Sheet1").Range("A1").Value = _
Sheets("Sheet1").Range("A1").Value + 1

For other ways to do this or if this is going to be used in a temple have a
look here
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

Signature

Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

> Hee, i have a problem.
> I like to print a file that has a number that changes every time that i
[quoted text clipped - 7 lines]
>
> Thansk in advange

Reply to this Message

Marc.paternotte - 18 Jun 2006 18:42 GMT

Thanks for the answer.

mvg

> Marc,
> A simple way would be to use something like this, in the before print
[quoted text clipped - 19 lines]
>>
>> Thansk in advange

Reply to this Message

Rate this thread: