Application-defined or object-defined error

**Endre111** · 03-14-2014, 03:36 PM

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** · 03-14-2014, 03:40 PM

Change Cells to Range

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

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

End If

PS Can you add code tags?

**Richard Buttrey** · 03-14-2014, 03:41 PM

Hi

Cells() syntax take row and column number parameters.

Try instead

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

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

End If

or

If Cells(7,4).Value = "USD/JPY" Then

Cells(7,9) = Cells(13,3) * Cells(7,8)

End If

**Endre111** · 03-14-2014, 03:48 PM

Thank you for the quick help.

I will use code tags in the future.

Application-defined or object-defined error

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Application-defined or object-defined error

Re: Application-defined or object-defined error

Re: Application-defined or object-defined error

Re: Application-defined or object-defined error

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] application-defined/object-defined error 1004 when trying to read from or write to cells

Opening Any Excel 2010 file get error 1004 Application defined or Object defined error

Application Defined or Object Defined Error, Command Button and Vlookup Function

[SOLVED] Copying A Range of Cells From one Sheet to Another - Error Application Defined or Object Defined

RE: Runtime error 1004- application defined or object defined erro

Bookmarks

Bookmarks

Posting Permissions