Application-defined or object-defined error

[Endre111]

Hello,

I would like to do the following calculation with and "if" function but I recieve the above error message..

I would appreciate if somone could help.


Sub calc()

If Cells("D7").Value = "USD/JPY" Then

Cells("I7") = Cells("C13") * Cells("H7")

End If

Best Regards,

Endre

[Norie]

Change Cells to Range

Please Login or Register  to view this content.

PS Can you add code tags?

[Richard Buttrey]

Hi

Cells() syntax take row and column number parameters.

Try instead

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[Endre111]

Thank you for the quick help.

I will use code tags in the future.