M
momotaro
Is there a way to increment a number in my spreadsheet each time I print?
Thanks in advance.
momo
Thanks in advance.
momo
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bernard Liengme
From previus post:
ThisWorksheet module
Private Sub Workbook_Open()
Range("Sheet1!G1") = Range("Sheet1!G1") + 1
End Sub
You may want to read J.E. McGimpsey's notes:
http://mcgimpsey.com/excel/udfs/sequentialnums.html
ThisWorksheet module
Private Sub Workbook_Open()
Range("Sheet1!G1") = Range("Sheet1!G1") + 1
End Sub
You may want to read J.E. McGimpsey's notes:
http://mcgimpsey.com/excel/udfs/sequentialnums.html
M
momotaro
Thanks for the info. Can the number be changed after I printed? For
example, I input info on the sheet and click print. After I click print, I
want the number increase to the next number. Can it be done? Thanks again.
example, I input info on the sheet and click print. After I click print, I
want the number increase to the next number. Can it be done? Thanks again.
B
Bernard Liengme
Use this workbook sub
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Range("Sheet2!A29") = Range("Sheet2!A29") + 1
End Sub
Note it updates BEFORE printing
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Range("Sheet2!A29") = Range("Sheet2!A29") + 1
End Sub
Note it updates BEFORE printing