ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   detect when columns being written to a worksheet “cross” a vertical page break (https://www.excelbanter.com/excel-worksheet-functions/211906-detect-when-columns-being-written-worksheet-%93cross%94-vertical-page-break.html)

gkb_cardiff

detect when columns being written to a worksheet “cross” a vertical page break
 

Hello.

I am trying to put some VB.NET code together that writes data to an
excel worksheet, column by column; however the code will need to detect
when a column “crosses” a vertical page break; I.E when the right hand
side of the page in print preview is crossed.

How do I detect when a column crosses the page break?

Gavin.




--
gkb_cardiff


All times are GMT +1. The time now is 04:51 PM.

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