'Using VB.net with Excel - How do I MOVE a Page Break?
I started to type a lengthy post but decided to get straight to the question. How do I MOVE a page break in Excel 2021? I have PCs with different versions of Office. Office 2021 seems to require a vba SET statement like
Set ActiveSheet.HPageBreaks(1).Location = Range("A69")
How can I do that in VB.net?
ALSO.. If I omit 'SET', the formatting is only completed properly in Excel 2021 when I place a debug break at this line, step through it, and run the rest of the code. If I remove the break or compile and run, the formatting is messed up!
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|