PDA

View Full Version : Solved: Excel Freezing When Macro Runs



Nurofen
11-09-2007, 03:14 PM
Hi,

I was just wondering if anyone knows why excel freezes when a macro is run?

1) i have V.1 and V.2
V.1 has no background colour
V.2 has background colour

it says calculating in the bottom right and then just freezes.:think:


Thank you for your time


Nurofen

Aussiebear
11-09-2007, 03:30 PM
And just what is the code in the macro?

Nurofen
11-09-2007, 03:33 PM
http://vbaexpress.com/forum/showthread.php?t=15913&page=2

post #28

works fine

but i've now coloured the sheets and it freezes :think:

Nurofen
11-09-2007, 03:53 PM
Funny but i just tested:

If I use countif =countif(A1:A10000,"cats") no problem V.1
If I use countif =countif($A$:$A$10000"b2") it freezes V.2

does anyone know why? :think:

Thank you for your time

Nurofen

XLGibbs
11-09-2007, 03:58 PM
I am assuming your second fomula actually has a , before the "b2"

=countif($A$1:$A$10000,B2) would be the correct way

Perhaps not using countif, or reducing the range (do you need to count 10,000 rows?)

XLGibbs
11-09-2007, 04:00 PM
Also, it isn't really "frozen" or dead, it is just that the CPU is too occupied with a hog of a formula (or an incorrect one that is having unintended consequences) to update the screen.

I have had the white screen of apparent death a number of times, but sometimes waiting it out will work.

Nurofen
11-09-2007, 04:10 PM
hI XLGibbs,


If I use countif =countif($A$:$A$10000"b2") it freezes V.2

ya typing too fast= If I use countif =countif($A$:$A$10000,"b2")

I have reduced the range works ok now.

Thanks mate :thumb

Thanking you for your time

Nurofen