Post your code and we'll look at it...

Could be almost anything...

--
steveB

Remove "AYN" from email to respond
"Tadragh1" wrote in
message ...

Dear Forumites,

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

I have a datafile of approximately 28000 rows and 6 columns. I am
executing a macro on it, which is making some data analysis. It runs
slowly, but it works until I add a formula to the last cell, where
there is a sum of range from A1 to A30000. The summing crashes the
macro. When I remove the summing from the Macro and put the formula in
the cell manually, it takes forever to sum. However, when I create a
new sheet within the SAME workbook and put the formula in the new
sheet, it sums the column in a blink. What may cause the problem? How
can I get over it? I need the sum to be in the same sheet and to be a
formula, not just a value (because when I change some parameters in the
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 A20000
and A20001 to A30000 and then summing those helps a bit, but it seems
to be quite a stupid workaround.

Thank You for Your time!


--
Tadragh1
------------------------------------------------------------------------
Tadragh1's Profile:
http://www.excelforum.com/member.php...o&userid=26252
View this thread: http://www.excelforum.com/showthread...hreadid=395486