Formula convert to VBA

[polki]

Hi,

i have formula for counting time period.

=IF(AND(E2=TODAY();(I2=""));NOW()-F2;"")

When i put to cell, it normally works. But i need it to insert this function via VBA and it doesn´t work. I got message "Runtime error '1004' Application or object - defined error"

I tried this:
Range("H2").Formula = "=IF(AND(E2=TODAY();(I2=""));NOW()-F2;"")"

Anyone know what i am doing wrong ? Thank you for reply.

[buran]

Please Login or Register  to view this content.

[BadlySpelledBuoy]

Try:

Range("H2").Formula = "=IF(AND(E2=TODAY(),(I2="""")),NOW()-F2,"""")"

[Norie]

Try this.

Please Login or Register  to view this content.

[polki]

Hi,

thank you for quick reply to all members !

This worked for me:
Range("H2").Formula = "=IF(AND(E2=TODAY(),(I2="""")),NOW()-F2,"""")"

Thank you again. i was using Semicolon between function and i was missing quotes.

[buran]

oh, the semicolon, I didn't notice that...