View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
thomsonpa thomsonpa is offline
external usenet poster
 
Posts: 31
Default setting page breaks based on value & printing to and from value

I am completely baffled as to whether this is possible.

I need a sheet to set page breaks to a maximum of 13 columns, then if the
value in column B is more than 04.00 (time value), insert a page break there.
This can be less than 13 columns. Then I need it to print the number of
pages up to this page break.
Next I need to continue from the 04.00 page break, and work down to 18.00,
doing the same thin, then print those pages (excluding the ones from the
beginning to 04.00.
Then a third run continuing to the end. From 18.00 to the end. Printing the
remaining pages.

Is this at all possible, or am I asking too much from excel.