'Then message box displays the address of the page break.Īfter the Location property is calculated, you may again select the original active cell. 'Example sets x equal to address of second horizontal page break. X = ActiveSheet.HPageBreaks(2).Location.Address
#Adobe number out of range code#
'Include code with Location property here. 'Select the last cell on the worksheet that has data. 'Set object "currcell" equal to active cell. For example, use the following code to select the end cell, use the Location property, and then reselect the original active cell: To prevent this problem, add code to select the last cell used in the worksheet before the code uses the Location property of horizontal or vertical page breaks. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. Microsoft provides programming examples for illustration only, without warranty either expressed or implied. MsgBox ActiveSheet.VPageBreaks(3).Location.Address MsgBox ActiveSheet.VPageBreaks(2).Location.Address
MsgBox ActiveSheet.VPageBreaks(1).Location.Address MsgBox ActiveSheet.HPageBreaks(2).Location.Address MsgBox ActiveSheet.HPageBreaks(1).Location.Address You use a Visual Basic for Applications macro in Microsoft Excel similar to the following code: The vertical or horizontal page break location is off the screen to the right of the visible window or below the visible window of the workbook. The active cell is above the horizontal page break or to the left of the vertical page break that is referred to by the HPageBreaks or VPageBreaks index. This problem may occur if the following conditions are true:
0 kommentar(er)
