+ Reply to Thread
Results 1 to 2 of 2

VBA to count # of pages not working

  1. #1
    Registered User
    Join Date
    03-15-2018
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    27

    Question VBA to count # of pages not working

    I'm working on a an electronic coaching log where conversations and observations are transcribed. Depending on the coach and the length of the visit, the log can be two pages or twenty pages. These logs need to have the ability to be printed out easily and the # of pages is tracked for research purposes. Right now, I'm using this code that requires a button and that the macro is run after the data has been entered:

    Please Login or Register  to view this content.
    I've attached the file and as you can see, it's not working correctly. What I really want is for the number of pages to be calculated automatically when the document is printed or saved and I want the print area to adjust to whatever the end of the table is. I hope this makes sense.

    Thank you!
    L
    Attached Files Attached Files
    Last edited by louhilla; 07-17-2018 at 10:52 AM. Reason: Fix per forum rules

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: VBA to count # of pages not working

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Print titles not working for additional pages
    By rcane in forum Excel General
    Replies: 0
    Last Post: 06-08-2018, 01:54 PM
  2. Listbox change Macro not working on multiple pages
    By ExcelNUBs in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-08-2014, 12:32 PM
  3. [SOLVED] Count Rows Based On User Input & Trigger Print Of Pages Out Of Count Result
    By wliang in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-09-2012, 02:45 AM
  4. help pages not working
    By embirath in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-24-2007, 10:02 PM
  5. Count number of pages
    By rm81 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-09-2006, 12:55 PM
  6. COUNT ACROSS SEVERAL PAGES
    By OZDOC1050 in forum Excel General
    Replies: 3
    Last Post: 09-05-2005, 02:05 PM

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