+ Reply to Thread
Results 1 to 1 of 1

Trying to count rows from manual page break to manual page break

  1. #1
    Registered User
    Join Date
    10-02-2014
    Location
    United States
    MS-Off Ver
    2007
    Posts
    6

    Trying to count rows from manual page break to manual page break

    Here is what I am trying to do:

    https://drive.google.com/file/d/0Bz8...it?usp=sharing

    I know the CountA formula to be =Counta(A1:AXX) will do what I want as I used it in the pages above. I've been trying to come up with the code that will automatically place that formula in the corresponding "H" row of the last line in the page. I've tried going off of some other page break code but can't seem to get it to work. Here is the code Im currently using:
    Please Login or Register  to view this content.
    This is a call log I made for my job. Whenever data is input to column A the time-stamp will reflect in column G automatically. If the entry is removed from Column A, the time stamp is then removed from column G. Then when you press "Enter" or "Tab" it will move to the next column instead of row. Once it gets to Column F, pressing enter or tab will return you to A column in the next row. It's very handy and this last little thing would make it perfect. Thanks!
    Attached Images Attached Images

+ 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. Find First match value and add page break, findnext value and add page break
    By dwx in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-20-2013, 12:58 PM
  2. [SOLVED] Page Layout (Page Break Preview) is not working with hidden rows in excel.
    By ebin charles in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-31-2013, 03:32 AM
  3. Way to count rows in print out and force page break?
    By SDBoca in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-07-2011, 12:12 PM
  4. Remove Manual Page Break
    By BK in forum Excel General
    Replies: 1
    Last Post: 08-11-2006, 10:05 AM
  5. [SOLVED] How do I show the manual page break?
    By angels in forum Excel General
    Replies: 1
    Last Post: 02-09-2006, 11:55 AM

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