Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to increase a number by 1 every time the spreadsheet opens?
Is there a way to have a number increase by 1 every time the excel
spreadsheet opens? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to increase a number by 1 every time the spreadsheet opens?
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 -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "SLD" wrote in message ... Is there a way to have a number increase by 1 every time the excel spreadsheet opens? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i have a cell number increase by 1 each time file opened | Excel Discussion (Misc queries) | |||
Spreadsheet opens very slowly | Excel Discussion (Misc queries) | |||
Number in cell increase with increase in font size. | Excel Discussion (Misc queries) | |||
EXCEL to update a number each time worksheet opens. | Excel Discussion (Misc queries) | |||
How to automtically increase a number every time a file is used | Excel Discussion (Misc queries) |