Do Macros find functions/formula's or the formula solution?

[RichTea88]

I'm currently trying to get this statement to work but I've been having no luck.

I was wondering If when I'm using a macro to check a cell and that cell has a formula in it. does it find the formula/function or its answer.

I have this code

Please Login or Register  to view this content.

and in cell 'Y66' I have this formula

Please Login or Register  to view this content.

Does the macro find Y66 as a '1' or does it just see the formula, because my macro isn't working and I'm unsure why.

[Izandol]

You are testing the value. However the formula returns "1" not 1 so you may require:

Please Login or Register  to view this content.

[RichTea88]

Cheers for your input dude!

I juggled a few things around in the reset of my procedure and managed to get it working. Thanks for that info anyway, always useful!