Excel macro: increase cell value?
What lines do I need in a macro to increment cell B4 on sheet "Calculations" by 7
I do not want to view sheet "Calculations" I just want to change/set a specific cell on that sheet
What lines do I need in a macro to increment cell B4 on sheet "Calculations" by 7
I do not want to view sheet "Calculations" I just want to change/set a specific cell on that sheet
garbo7441
Favorite Answer
You can also use this shorter method:
Sheets("Calculations").[B4] = Sheets("Calculations").[B4] + 7
Ron
This would go inside your macro..
Val_B4 = Worksheets ("Calculations").Range("B4").Value
Worksheets ("Calculations").Range("B4").Value = Val_B4 + 7