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.
Bookmarks