Post your macro, then we might have a clearer idea of what you are
trying to do.

Pete

On Jan 14, 2:39*pm, orquidea
wrote:
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