Hi

I have a long macro which generates a report with a weekly ammount of data.
When I pull up data from the whole year I get the error 6 "overflow" and the
line
oursupply=(oursupply/totalsupply) is higlighted.
The macro in general doesn't work properly, it doesn't insert empty rows
where I have set it to do, it is not counting and so on. However, when I
run it with a weekle amount of data the macro works perfectly.

Could anyone help me to understand what is wrong in this macro or why it
doesn't work with a larger ammount of data.

Thanks in advance for your help.

Orquidea