T
thomsonpa
This is a very difficult area for me to understand with my limited visual
basic knowledge.
I have a worksheet which has different ammounts of information on it each
day.
I am looking for the visual basic code to automate the printing.
I want each page to have a maximum of 14 rows. and the pages need to be
printed out after running 3 individual sets of macros, so what I am looking
for is:
column B from row 7 down contains a time (formatted 01:20:00AM), I need the
macro to set the print areas to max 14 rows, plus down to 4, am. then how
many pages to print. ie from 1 to 3.
then a seperate macro to run later from 4 am to 4 pm in column B, to set
print areas, then print pages 4 to 7, then a third time from 4 pm to the end
of the sheet.
The position of the times will change daily, so the number of sheets to
print in each stage will change daily.
This seems complicated, but has anybody got any ideas.
basic knowledge.
I have a worksheet which has different ammounts of information on it each
day.
I am looking for the visual basic code to automate the printing.
I want each page to have a maximum of 14 rows. and the pages need to be
printed out after running 3 individual sets of macros, so what I am looking
for is:
column B from row 7 down contains a time (formatted 01:20:00AM), I need the
macro to set the print areas to max 14 rows, plus down to 4, am. then how
many pages to print. ie from 1 to 3.
then a seperate macro to run later from 4 am to 4 pm in column B, to set
print areas, then print pages 4 to 7, then a third time from 4 pm to the end
of the sheet.
The position of the times will change daily, so the number of sheets to
print in each stage will change daily.
This seems complicated, but has anybody got any ideas.