| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
LOCATION OF WORKSHEET'S AUTOMATIC PAGEBREAKS
i want to know the syntax for knowning the location of worksheet's automatic
pagebreaks. -- Anupam Soral |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
LOCATION OF WORKSHEET'S AUTOMATIC PAGEBREAKS
|
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatic location and order of DataLabels? | Charts and Charting in Excel | |||
| Excel automatic backup location | Excel Discussion (Misc queries) | |||
| automatic offset cell location when there is a value in a selected cell. | Excel Worksheet Functions | |||
| check whether worksheet's there or not | Excel Programming | |||
| Compare Worksheet's | Excel Programming | |||
Linear Mode
