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

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

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.

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!