I have a vba macro that inserts about 4 lines of text in the excel footer. To make it simple, if I have a one page worksheet and the data contained in the excel worksheet is almost to the page break, once I insert the footer via the macro and print preview the document, the footer overlaps some of the data at the bottom of the page.
In ms word, a page break will automatically be created but not in excel. How can I check if the footer is going to overlap the data in vba?
Any help would be appreciated.