Print Simple Report from User form with Total.

**ebin charles** · 07-02-2011, 10:29 AM

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** · 07-02-2011, 11:09 AM

Hi Charles,

The total row keeps moving down because of the line:

ws.Cells(lrow, 7).EntireRow.Insert

in the userform1 code.

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

**ebin charles** · 07-02-2011, 11:18 AM

Originally Posted by MarvinP

Hi Charles,

The total row keeps moving down because of the line:

ws.Cells(lrow, 7).EntireRow.Insert

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