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
-
How to control IE from VBA
by NaseemAhmed (0 replies)
-
Excel 2007 Error : ' the digital signature is deleted when Excel users tries to save the Master Excel Spreadsheet.'
by jdierkes (0 replies)
-
Excel VBA transposition problem
by KDHTSVAU (2 replies)
-
excell question
by Uncle (11 replies)
-
Question about subforms
by ginwah (0 replies)
This thread is for discussions of Increment Cell Value.