Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
setting print ranges to print based on option | Excel Programming | |||
Setting print range using VBA | Excel Programming | |||
Setting print range using VBA | Excel Programming | |||
Setting print range using VBA | Excel Programming | |||
Setting Print range | Excel Programming |