Hello,





I have a spreadsheet that is set up as an invoice.

When I run a macro to create a new invoice it clears the details that were
entered in the previous invoice and when the new invoice opens before I
enter any details I am getting the following error #VALUE! in G:48
(Discount) and G:49 (Total).

The formula I have in G:48 is =-G46*DISCOUNT (Discount is a named range in
H:9)

The formula I have in G:49 is =SUM(G46:G48)

Could somebody please help me with rewriting the formulas in G:48 and G:49
so as not to get the error #VALUE! when a new invoice is opened. Ideally I
would like these cells to be blank when the new invoice is created.



Any help or suggestions would be most welcome.





Eamon