"Steve",
Basically you need a macro. If you've never used one, start with Tools >>
Macro >> Record New Macro. The name should default to Macro1. Make sure
"Store Macro In" is set to "This Workbook" and click OK.
The Stop Recording toolbar should appear (if it doesn't, use View >>
Toolbars). Click the Stop button.
Press ALT+F8, highlight Macro1, click Edit.
Replace anything between the first and last lines with
Range("A1") = Range("A1") + 1
, so you end up with
Sub Macro1()
Range("A1") = Range("A1") + 1
End Sub
Then you can run it via ALT+F8.
The big question is when, ie: at what stage of your process? It could be set
up to run automatically when the file is opened, but that's not recommended.
If you're setting up an invoice-type-thing, it could make sense to run it
after printing (in which case you would probably use code to print, reset
the form, then change the number).
Post back if you need more info.
HTH,
Andy
