After spending countless hours of searching my issue I decided to register at this forum for help.
I make quotations using excel and with the help of vba I automate some things. Now I want to place the area for signatures on the bottom of the A4-papersize page in excel. However, I cannot figure out how to determine the last row on the page.
I can figure out the last used row:
Sheets("Offerte").UsedRange.Rows.Count
But as there are cells with text wrapping I need the vba code to also return the last row of the page. I was thinking of adjusting the "UsedRange" to firstpage or something like that, but that didn't work either.
Any suggestions?