A Anupam Soral Jul 4, 2008 #1 i want to know the syntax for knowning the location of worksheet's automatic pagebreaks.
G Gary''s Student Jul 4, 2008 #2 http://groups.google.com/group/micr...lnk=gst&q=locate+page+breaks#f53ca12cc0b72355
M Mike H Jul 4, 2008 #3 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
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
