Hi Mark

how many consecutive numbers would you want to create at any one time ...
on the second click on the command button would you want to replace the
number in A2 with the next number after A1 or would you want to find the
next blank line and put the next consecutive number in there?
what do you want to happen if someone re-orders the column .. is the next
number to be generated one more the physically last number in the column or
one more than the maximum number in the column?

Cheers
JulieD

"Mark" wrote in message
...
Can I ask someone how I would go about getting the
results I want for the following points.
1. If I wanted to generate consecutive numbers when
I hit a command button how would this be done?
2. How would I get the first number in cell A1 then
A2 and so on?
3. If I want to start the numbers at 457.

Thanks for any help in this matter.