I am trying to insert a macro or VB to keep track of numbering in a template. I have the following:
sub inc()
range("a1").value=range("a1").value+1
end sub
It works for numbering but I would like it to keep track of the last number assigned so when it runs again, it inserts the next sequential number. Any clue?
sub inc()
range("a1").value=range("a1").value+1
end sub
It works for numbering but I would like it to keep track of the last number assigned so when it runs again, it inserts the next sequential number. Any clue?