How to make a seril number continue
Solved/Closed
SARC
Posts
29
Registration date
Saturday 7 August 2010
Status
Member
Last seen
31 August 2010
-
19 Aug 2010 à 10:22
SARC - 21 Aug 2010 à 23:16
SARC - 21 Aug 2010 à 23:16
Related:
- Continue number
- Potplayer continue where you left off - Guide
- Keyboard not found press f1 to continue - Guide
- Hardware acceleration is disabled. please enable it to continue - Guide
- Continue with these tabs - Guide
- How to delete continue watching on samsung tv home screen - Guide
2 responses
Hi there,
From first cell lets say F1,enter 101,F2 enter 102,F3 l03 ,now with mouse select F1 to F3 dragging it down to number desired it will be in serial.
Thanks
From first cell lets say F1,enter 101,F2 enter 102,F3 l03 ,now with mouse select F1 to F3 dragging it down to number desired it will be in serial.
Thanks
SARC
Posts
29
Registration date
Saturday 7 August 2010
Status
Member
Last seen
31 August 2010
20 Aug 2010 à 14:47
20 Aug 2010 à 14:47
Ok thanks,.. I got this far with my knowledge of VBA...
Private Sub Workbook_Open()
End Sub
You think you can help me out with the rest of the code pls...
Private Sub Workbook_Open()
End Sub
You think you can help me out with the rest of the code pls...
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
20 Aug 2010 à 16:25
20 Aug 2010 à 16:25
Private Sub Workbook_Open()
Sheets("Sheet1").Range("A5") = Sheets("Sheet1").Range("A5") + 1
End Sub
Sheets("Sheet1").Range("A5") = Sheets("Sheet1").Range("A5") + 1
End Sub
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
21 Aug 2010 à 05:55
21 Aug 2010 à 05:55
look in cell A5 of sheet titled Sheet1
19 Aug 2010 à 13:14
20 Aug 2010 à 10:09
You can either have number increase when book is open or close. for that open VBE (ALT + F11) and press CTRL + R and then double click on "ThisWorkbook". There depending on you want to go for close or open, pick the right event from the drop down and code it there