See J.E. McGimpsey's site for some sample code:

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

Which may help.
--
Regards,
Tom Ogilvy

"Michael" wrote in message
...
My boss was asking me to make a macro that could do something like this.

The workbook has 7 sheet's, each sheet is a report, sheet 1 is an x-ray
report, sheet 2 is an dyepen report etc etc. Every report has its own
report
number (from report 1 to .....). My boss's problem is that different
user's
use a report number that may have been used before. He want's me to make a
macro that controll the input on every report, thats not a problem.

My problem is that, in cell D5, the report number should +1 for every time
a
report is made. Also, the first time its opened it should be 1 the second
time its opened it should be 2, and this only for the active sheet. Is
this
possible?