+ Reply to Thread
Results 1 to 2 of 2

Counter

  1. #1
    Forum Contributor
    Join Date
    07-22-2008
    Location
    canada
    Posts
    123

    Counter

    Hi. I would like to create a sort of a counter on my spreadsheet. Please help.

    A1 has 0 numeric value. If the worksheet is sent to the printer for the first time, A1 should be incremented automatically by 10, then the 2nd time worksheet is sent to the printer, A1 should then be automatically incremented by 10 again, which would result as 20...and so on. thank you very much.

  2. #2
    Forum Contributor
    Join Date
    07-24-2009
    Location
    Valrico, FL USA
    MS-Off Ver
    Excel 2016
    Posts
    358

    Re: Counter

    Try a search for:
    Private Sub Workbook_BeforePrint(Cancel As Boolean)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1