Question

EXCEL VBA 分页符位置

EXCEL中怎么查找分页符位置并返回下图中分页符的行列值？

Answer 1

Dim a As Range, b As String, c As String
Set a = ActiveWindow.SelectedSheets.HPageBreaks(1).Location
b = a.Row
c = a.Column
不知道你要具体要怎样操作，看看这样成不成吧