Library code snippets
Increment Cell Value
By Neil Derek, published on 23 Feb 2002
This extremely simple macro increments the value in a cell. You could use this for unique id's on invoices, delivery notes, etc...
Sub Increment()
' change A1 to the cell you wish to increment
Range("A1").Value = Range("A1").Value + 1
End Sub
Related articles
Related discussion
-
Searching for several parameters with one dropdown selection
by egallen (1 replies)
-
VBA macro Help-plzzzzzzzzzzzzzzzzzzzzzz
by Uncle (2 replies)
-
Enable Formula Audting in an Excel Workbook where all the sheets are protected
by raviarul (0 replies)
-
Listing table in Access VIA code
by merkava (1 replies)
-
How to deal with the brackets?
by jitender.gupta007 (1 replies)
This thread is for discussions of Increment Cell Value.