VPageBreaks object (Excel)
A collection of vertical page breaks within the print area.
Remarks
Each vertical page break is represented by a VPageBreak object.
When the Application property, Count property, Creator property, Item property, Parent property, or Add method is used in conjunction with the VPageBreaks property:
For an automatic print area, the VPageBreaks property applies only to the page breaks within the print area.
For a user-defined print area of the same range, the VPageBreaks property applies to all of the page breaks.
Example
Use the VPageBreaks property of the Sheets object to return the VPageBreaks collection. Use the Add method to add a vertical page break.
If you add a page break that does not intersect the print area, the newly-added VPageBreak object does not appear in the VPageBreaks collection for the print area. The contents of the collection may change if the print area is resized or redefined.
The following example adds a vertical page break to the left of the active cell.
ActiveSheet.VPageBreaks.Add Before:=ActiveCell
Methods
Properties
See also
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
피드백
https://aka.ms/ContentUserFeedback
출시 예정: 2024년 내내 콘텐츠에 대한 피드백 메커니즘으로 GitHub 문제를 단계적으로 폐지하고 이를 새로운 피드백 시스템으로 바꿀 예정입니다. 자세한 내용은 다음을 참조하세요.다음에 대한 사용자 의견 제출 및 보기