View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
thomsonpa thomsonpa is offline
external usenet poster
 
Posts: 31
Default setting print range based on looking up values

If column "B" contains time formulas (1:20:00 AM), etc. is it possinble to
create a macro to search through this column, find the last cell in column
"B" that is less than 04:00:00 AM, insert a page break and set the print
range to that cell?

then the next command to look for all cells vaued between 04:00:00 AM and
16:00:00 PM, insert another page break, and print that range.

Then finally, from 16:00:00 PM to end, set print range.

I also need to know if it is possible to set the maximum number of rows
before a page break to 14.