Thank you both. very useful
--
Tdp
"JLatham" wrote:
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" wrote:
Thanks for that J.
I assume if it`s in sheet4 then I write
Worksheets("Sheet4").Range("D4") = Range("E4")*Range("F4")
?
--
Tdp
"JLatham" wrote:
Range("D4") = Range("E4")*Range("F4")
"Tdp" wrote:
How do I write
D4=E4*F4
as a vb code
--
Tdp