Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ADD 1 TO CELL UPON PRINTING

Status
Not open for further replies.

dance

Technical User
Nov 6, 2002
142
US
I have a cell in an Excel worksheet that I want to add 1 to each time the page is printed.
For example 4300 this time, 4301 next time, 4302 next.
I know this is easy, but I don't have a clue as to how to begin.
 
Hi,

Code:
With Activeworkbook.Worksheets("The Sheet with My Counter").[A1]
  .Value = .Value + 1
End With


Skip,
[sub]
[glasses] [red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it! [tongue][/sub]
 

There is a BeforePrint event on the workbook that you could use.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top