R
R Mdld
I have a long list in a worksheet grows and wanes with
data entered deleted and I need to print just the part of
the list that actaully has data in it. I understand how
to set a dynamic range but the question is, how to set up
a vb routine to select the range, format it to fit on a
page(s) and print it. My dynamic range setting formula is
=OFFSET('Payables Matl'!$B$6,0,0,COUNTA('Payables Matl'!
$B:$B),11). There is already a print_area range set that
is larger than the the dynamic range mentioned here that
I don't want to disturb the print setting for. Can anyone
give me some guidance with this?
Thanks for the help,
Ron
data entered deleted and I need to print just the part of
the list that actaully has data in it. I understand how
to set a dynamic range but the question is, how to set up
a vb routine to select the range, format it to fit on a
page(s) and print it. My dynamic range setting formula is
=OFFSET('Payables Matl'!$B$6,0,0,COUNTA('Payables Matl'!
$B:$B),11). There is already a print_area range set that
is larger than the the dynamic range mentioned here that
I don't want to disturb the print setting for. Can anyone
give me some guidance with this?
Thanks for the help,
Ron