Code to multiply two cells?

T

Tdp

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

Gary''s Student

You can qualify all the pieces:

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

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

Tdp

Thank you both. very useful
--
Tdp


JLatham said:
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.
Click to expand...
 
Top