Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I add one to a number everytime I open the same workbook
I have a cell number like 1001 and I want it to add to 1002 the next time I
open ithe workbook and 1003 the next time and so on Thanks Greg |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I add one to a number everytime I open the same workbook
Private Sub Workbook_Open()
With Worksheets("Sheet1").Range("A1") .Value = .Value + 1 End With End Sub 'This is workbook event code. 'To input this code, right click on the Excel icon on the worksheet '(or next to the File menu if you maximise your workbooks), 'select View Code from the menu, and paste the code -- HTH RP (remove nothere from the email address if mailing direct) "Greg" wrote in message ... I have a cell number like 1001 and I want it to add to 1002 the next time I open ithe workbook and 1003 the next time and so on Thanks Greg |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I add one to a number everytime I open the same workboo
Thanks so Very Much
God Bless Greg "Bob Phillips" wrote: Private Sub Workbook_Open() With Worksheets("Sheet1").Range("A1") .Value = .Value + 1 End With End Sub 'This is workbook event code. 'To input this code, right click on the Excel icon on the worksheet '(or next to the File menu if you maximise your workbooks), 'select View Code from the menu, and paste the code -- HTH RP (remove nothere from the email address if mailing direct) "Greg" wrote in message ... I have a cell number like 1001 and I want it to add to 1002 the next time I open ithe workbook and 1003 the next time and so on Thanks Greg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When I open a workbook, another one called Book1 is also opened. W | Excel Discussion (Misc queries) | |||
Links only update when external workbook is open | Excel Worksheet Functions | |||
Calc status of open excel workbook should not overwrite another | Setting up and Configuration of Excel | |||
Importing Data from unopened Workbook into an open Workbook | Excel Discussion (Misc queries) | |||
Sumif Linking to Another Workbook error #VALUE! | Excel Discussion (Misc queries) |