_change vs _calculate (ByVal) problem

[DimAvr]

Thanks to some experienced forum users, I've managed to bypass 3 formatting condition limit (excel 2003). However, this works only for values and not for formulas.

How do I make this work when there is a formula in A1?

Also, I think I know what is going on in the code, but I'm having trouble understanding what the fourth line does.
I would appreciate if someone could provide a short explanation. Too be specific - What does VarType do (I'm familiar with .value2 property), and what is vbDouble?

I don't really understand this explanation I've found - Double-precision floating-point number :/

Code bellow,

Thank you

Please Login or Register  to view this content.

[:) Sixthsense :)]

This will do the same work....

Please Login or Register  to view this content.

[DimAvr]

Oh, great, very clever.
Is there a way for the code to work when there is a formula in A1? That is what's bothering me

[:) Sixthsense :)]

Add the below code also in your workbook code window...

Please Login or Register  to view this content.

[DimAvr]

That's it!

Thanks Sixthsense

[:) Sixthsense :)]

Glad it helps you and thanks for the feedback