Printable View
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
And just what is the code in the macro?
http://vbaexpress.com/forum/showthre...t=15913&page=2
post #28
works fine
but i've now coloured the sheets and it freezes :think:
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
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?)
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.
hI XLGibbs,
ya typing too fast= If I use countif =countif($A$:$A$10000,"b2")Quote:
If I use countif =countif($A$:$A$10000"b2") it freezes V.2
I have reduced the range works ok now.
Thanks mate :thumb
Thanking you for your time
Nurofen