Solved: Excel Freezing When Macro Runs

[Nurofen]

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.


Thank you for your time


Nurofen

[Aussiebear]

And just what is the code in the macro?

[Nurofen]

http://vbaexpress.com/forum/showthre...t=15913&page=2

post #28

works fine

but i've now coloured the sheets and it freezes

[Nurofen]

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?

Thank you for your time

Nurofen

[XLGibbs]

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]

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]

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

Thanking you for your time

Nurofen