How to increase a number by 1 every time the spreadsheet opens?

  • Thread starter Thread starter SLD
  • Start date Start date
With a Workbook open even macro such as

Private Sub Workbook_Open()
Range("Sheet1!A1").Value = Range("Sheet1!A1").Value + 1
End Sub

Open the VBA editor, right click ThisWorkbook for the file in question and
use View Code
Paste this macro into the module

New to VBA? See

David McRitchie's site on "getting started" with VBA

http://www.mvps.org/dmcritchie/excel/getstarted.htm

Debra Dalgleish's "Adding Code to a Workbook"

http://www.contextures.com:80/xlvba01.html

best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro for a "counter" 2
increase an entire spreadsheet by a percentage 2
Increasing a whole Spreadsheet by a percent 1
Increasing by a percent 1
Adding 1
Increasing all values in spreadsheet by same percentage. 1
Increment Value By 1 Each Time Spreadsheet is Opened 2
increase existing cells 3

Back
Top