After scouring the web and this forum to no avail, I am reaching out for help. Long story short, I am creating a logbook for flying purposes, and am creating a Macro to copy all of the logbook data and format it for printing. I have already figured out most of what I need, but a problem presented itself yesterday when i opened the file on a separate computer. The print area changed on my laptop vs. my work computer, and while my code accounted for creation of new rows with respect to page breaks, the formulas did not.
I would like to have the VBA count the number of rows on only one printed page (between page breaks) and output that as an integer value, then utilize that value for formula generation. could someone give me a simple way to count only the number of cells on ONLY ONE page being printed (# of cells between page breaks). All rows are the same size and I only need to have to code count the number of rows on ONE page. Once I have that value, i am confident that I can put that VBA output into a formula. If you need specifics on the code I have, let me know, however I just need conceptually how to do the row count for a single page. Thanks for everyone's time!
I would like to have the VBA count the number of rows on only one printed page (between page breaks) and output that as an integer value, then utilize that value for formula generation. could someone give me a simple way to count only the number of cells on ONLY ONE page being printed (# of cells between page breaks). All rows are the same size and I only need to have to code count the number of rows on ONE page. Once I have that value, i am confident that I can put that VBA output into a formula. If you need specifics on the code I have, let me know, however I just need conceptually how to do the row count for a single page. Thanks for everyone's time!
