Code to multiply two cells?

[Tdp]

How do I write
D4=E4*F4
as a vb code

 

[JLatham]

Range("D4") = Range("E4")*Range("F4")

 

[Tdp]

Thanks for that J.
I assume if it`s in sheet4 then I write
Worksheets("Sheet4").Range("D4") = Range("E4")*Range("F4")
?

 

[Gary''s Student]

You can qualify all the pieces:

Sub dural()
With Worksheets("Sheet4")
..Range("D4") = .Range("E4") * .Range("F4")
End With
End Sub

 

[JLatham]

As I wrote it, it would automatically apply to the "active sheet".

But since you may want it to go to another sheet, then the way you wrote it
would work. Might have to treat the E4 and F4 references the same way also,
i.e. specifically referencing the worksheet(s) they are on also.

Other than taking a little extra time to resolve the location, it never
hurts to use the worksheet name along with the address; and sometimes it is a
must do.

 

[Tdp]

Thank you both. very useful
--
Tdp

As I wrote it, it would automatically apply to the "active sheet".

But since you may want it to go to another sheet, then the way you wrote it
would work. Might have to treat the E4 and F4 references the same way also,
i.e. specifically referencing the worksheet(s) they are on also.

Other than taking a little extra time to resolve the location, it never
hurts to use the worksheet name along with the address; and sometimes it is a
must do.