Thread: [Solved] Problem Coding End of Page
View Single Post
 
Old 10-12-2017, 04:22 PM
DRD992 DRD992 is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Jan 2016
Posts: 11
DRD992 is on a distinguished road
Default Problem Coding End of Page

Everyone,

I'm having trouble writing a macro that will automatically position the text ("Continued...") on the very last line of page. My problem is coding the variable distance between the preceding text and "Continued." I don't have trouble coding the letters or words, only reliably positioning.

I prefer to avoid page breaks and footers because they waste too much space at the bottom of a page.

When I try to create a looping carriage return, to position the cursor on the last line of a page, I invariably create an infinite loop.

I've unsuccessfully tried creating code that would calculate the number of lines needed to move "Continued..." from a higher position on the page to the last line.

Any suggestions? Thank you
Reply With Quote