ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   setting print range based on looking up values (https://www.excelbanter.com/excel-programming/402910-setting-print-range-based-looking-up-values.html)

thomsonpa

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.


All times are GMT +1. The time now is 05:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com