[RESOLVED] value of formula in vba EXCEL

[sweet_dreams]

Hi all,

I have such a problem. I would like my code to depend of cells value. But problem is that in this cell there is formula which returns value. How can I make my program read this value.

for example: In A1 i have formula if(b1>0;1,-1)

and programmatically I would like to do sth like that

if range("a1").value = 1 then 
'my code
end if

the problem is that when value in cell A1 comes form formula code shown above doesn't work.

Please help.

Regards,
sweet_dreams