VBA Sum in Column

[ManUBlueJay]

I have a 10,000 cell long Range single Col Named MyRange.
Is it possible in VBA to have each number in that range to be increased by a sum of 1.
Example 3.1 becomes 4.1, 4.1 becomes 5.1....

 

[Rick Rothstein]

I have a 10,000 cell long Range single Col Named MyRange.
Is it possible in VBA to have each number in that range to be increased by a sum of 1.
Example 3.1 becomes 4.1, 4.1 becomes 5.1....

Are there other values in the cells that are not numbers (blank cells, text, formulas)?

 

[ManUBlueJay]

No, All Numerical numbers, some whole, some decimal

 

[Rick Rothstein]

No, All Numerical numbers, some whole, some decimal

This should do what you want...

Sub AddOneOtMyRange()
  [MyRange] = [MyRange+1]
End Sub

 

[ManUBlueJay]

It inserts a #Value error instead of the new sum

 

[ManUBlueJay]

My Error. I had a mistype. It works like a dream.
Thanks a bunch