ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to select the last row before the page break on an Excel sheet (https://www.excelbanter.com/excel-programming/384648-how-select-last-row-before-page-break-excel-sheet.html)

Michel

How to select the last row before the page break on an Excel sheet
 
Hello. I would like to know if there is a VBA command to get the last row of
page no1 of a Excel sheet. The last row should be the one which is at the
horizontal page break of page no1. The same question for the 1st colomn in
page no1, the last colomn in page no1 and the 1st row of page no1.
Thanks a lot. regards. Michel


All times are GMT +1. The time now is 02:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com