Adding 1 to each row without using for loop in VBA

Looking for an easy way to add a certain number to each row in a column. From this:

to this:

https://stackoverflow.com/questions/66739751/adding-1-to-each-row-without-using-for-loop-in-vba March 22, 2021 at 10:53AM