Print Simple Report from User form with Total.

[ebin charles]

Hey sir,

I have excel vba to maintain client account receivable.
I can enter invoice details & I can enter new client details.

But when I enter one invoice, it insert a column before Total row. So the total
row keeps on moving down when you enter invoice.
But I need printout including total row.

Here I cannot set printout area with total row.

Can anyone help me in this thread?

Charles

[MarvinP]

Hi Charles,

The total row keeps moving down because of the line:

Please Login or Register  to view this content.

in the userform1 code.

I'm not sure if you want to leave this line out or expand your print area.

[ebin charles]

Hi Charles,

The total row keeps moving down because of the line:

Please Login or Register  to view this content.

in the userform1 code.

I'm not sure if you want to leave this line out or expand your print area.

Thank you for you response.

But Is it possible if I name the TOTAL Row as " Total" and to set the
print area to cover until the the name "TOTAL"?

So I can expand my print area till the "TOTAL" area is reached.
Is it possible?

Regards
Charles

[MarvinP]

Hi Charles,

It looks like there are a lot of hits on this topic on the net.
http://www.mrexcel.com/archive/Printing/30490.html
http://excel-tips.blogspot.com/2008/...-in-excel.html - I like this one!
http://www.teachexcel.com/excel-help...php?i=141660#4 for many examples.

[ebin charles]

Thank you for such great idea.
But I am not getting the TOTAL row with printable
area.

Is there any code to use?

Regard
Charles