Consecutive in VBasic for Excel

It’s actually very easy, suppose the field you want to increase is cell F5, well all you need to do is create a macro and assign it the name you want, in my case I named it increase, now you click on it in create, then Excel will open the visual basic editor for applications with the name of your new function without code, in there you write the following:

Range(“F5”).Select
ActiveCell.FormulaR1C1 = Range(“F5”).Value + 1

You would have something as follows:

Sub Increment()
Range(“F5”).Select
ActiveCell.FormulaR1C1 = Range(“F5”).Value + 1
End Sub

You save it and assign a hot key in options within the macro view and that’s it, each time you execute it, the value stored in cell F5 will increase by 1.

Greetings to all.