Cell with automatic numeration


Posted by Jorge on November 22, 2001 7:35 AM

How I can do an automatic numeration in a cell (for any kind of forms: invoices, notes, ...)?



Posted by Lewis on November 23, 2001 3:51 PM

I have the following at the end of my macro to increase the value in D4 by 1 each time the macro is run.

Sheets("Enter").Select
Range("D4").Select
ActiveCell.Value = ActiveCell.Value + 1

It should work

Lewis