Code to multiply two cells?
 

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

Answer: Code to multiply two cells?
 

To write the code to multiply two cells in Excel using VBA, you can use the following code:

This code will multiply the values in cells E4 and F4 and then store the result in cell D4.

Here's a step-by-step guide on how to write this code:

1. Open the Excel workbook where you want to write the code.
2. Press ALT + F11 to open the VBA editor.
3. In the VBA editor, click on Insert Module to create a new module.
4. In the new module, type the following code:
   
   
   Formula:

   ---

   Sub MultiplyCells()
    Range("D4").Value = Range("E4").Value * Range("F4").Value
End Sub 


   ---

5. Save the module and close the VBA editor.
6. Go back to the Excel workbook and select the cell where you want to run the code (e.g. D4).
7. Press ALT + F8 to open the Macro dialog box.
8. Select the MultiplyCells macro and click on Run.
9. The code will run and the result of the multiplication will be displayed in cell D4.

That's it! You have now written a VBA code to multiply two cells in Excel.

Code to multiply two cells?
 

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


"Tdp" wrote:

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

Code to multiply two cells?
 

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

Code to multiply two cells?
 

You can qualify all the pieces:

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

--
Gary''s Student - gsnu200808


"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

Code to multiply two cells?
 

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

Code to multiply two cells?
 

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