Hi there,
I need to keep memorized a progressive number in a function.
I have a file with some invoices to be repeated in a new sheet, the invoices have a progressive number. This number is relevant to avoid double registration in the new sheet. How can I keep this number in a function and start from it for updating.
At the moment I am using a cell in a worksheet (but I 'd like to use a function)
protocol_number = activecell.value (I get the prot nr in a sub)
range("a1000")=protocol_number
different sub
if Range("a1000") = activecell.value then
Msgbox "the protocol number has been registered yet"
else
update code
Thanks for helping me