ExcelBanter - LOCATION OF WORKSHEET'S AUTOMATIC PAGEBREAKS

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - LOCATION OF WORKSHEET'S AUTOMATIC PAGEBREAKS (https://www.excelbanter.com/excel-programming/413561-location-worksheets-automatic-pagebreaks.html)

Anupam Soral

LOCATION OF WORKSHEET'S AUTOMATIC PAGEBREAKS

i want to know the syntax for knowning the location of worksheet's automatic
pagebreaks.
--
Anupam Soral

Gary''s Student

LOCATION OF WORKSHEET'S AUTOMATIC PAGEBREAKS

http://groups.google.com/group/micro... a12cc0b72355
--
Gary''s Student - gsnu200794

Mike H

LOCATION OF WORKSHEET'S AUTOMATIC PAGEBREAKS

Try

Sub stantive()
ActiveWindow.View = xlPageBreakPreview
For Each break In ActiveSheet.HPageBreaks
MsgBox "A" & break.Location.Row
Next break
ActiveWindow.View = xlNormalView
End Sub

Mike

"Anupam Soral" wrote:

i want to know the syntax for knowning the location of worksheet's automatic
pagebreaks.
--
Anupam Soral

All times are GMT +1. The time now is 09:27 PM.