Dear Forumites,

I am new here and just wanted to ask my first question. I am a Visua
Basic newbie, so it may be naive, but I couldn't find the answe
anywhere.

I have a datafile of approximately 28000 rows and 6 columns. I a
executing a macro on it, which is making some data analysis. It run
slowly, but it works until I add a formula to the last cell, wher
there is a sum of range from A1 to A30000. The summing crashes th
macro. When I remove the summing from the Macro and put the formula i
the cell manually, it takes forever to sum. However, when I create
new sheet within the SAME workbook and put the formula in the ne
sheet, it sums the column in a blink. What may cause the problem? Ho
can I get over it? I need the sum to be in the same sheet and to be
formula, not just a value (because when I change some parameters in th
sheet, I need to be able to see the sum changing in the same time).
I also noticed, that creating sums from A1 to A10000, A10001 to A2000
and A20001 to A30000 and then summing those helps a bit, but it seem
to be quite a stupid workaround.

Thank You for Your time

--
Tadragh
-----------------------------------------------------------------------
Tadragh1's Profile: http://www.excelforum.com/member.php...fo&userid=2625
View this thread: http://www.excelforum.com/showthread.php?threadid=39548