setting print range based on looking up values

T

thomsonpa

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Break Calculation Macro 1
separating date and time 5
VBA Validation between two Times 17
Excel VB to create and send an outlook appointment with html code 1
Vlookup/Hlookup confusion 1
Programmatically inserting a page break 0
Formula For Time Duration Calculation 2
Need Help With My Loop That Creates Output File 5

Top