Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Eliot K
Lv 7
Eliot K asked in Computers & InternetSoftware · 8 years ago

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

2 Answers

Relevance
  • garbo7441
    Lv 7
    8 years ago
    Favorite Answer

    You can also use this shorter method:

    Sheets("Calculations").[B4] = Sheets("Calculations").[B4] + 7

  • Ron
    8 years ago

    This would go inside your macro..

          Val_B4 = Worksheets ("Calculations").Range("B4").Value

          Worksheets ("Calculations").Range("B4").Value = Val_B4 + 7

Still have questions? Get your answers by asking now.