![]() |
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