View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JR_06062005
 
Posts: n/a
Default Detect page break settings

Is there a way to detect where a page break setting occurs?

I've formatted cells so that their content will be invisible except when a
heading break occurs (I've solved that problem) or when a page break occurs.
I'm using Conditional Formatting to accomplish this.

Could someone either tell me a way to detect where page breaks occur or
suggest a better way of accomplishing my objective?