One more way based on the last row in column D:

Option Explicit
Sub testme01()
Dim myRng As Range
With ActiveSheet
Set myRng = .Range("F2:F" & .Cells(.Rows.Count, "D").End(xlUp).Row)
myRng.Formula = "=d2*e2"
End With
End Sub

You can plop the formula into the range all at once (like selecting the range,
typing in the formula and hitting ctrl-enter manually).

And you don't need that =sum() portion in your formula.
=d2*e2 is sufficient.

pcscsr wrote:

All I need to do is code in vba the following formula:

=sum(d2*e2) and have the total in column f. The formula then is
copied down the column with the row changes. for example =sum(d3*e3)
and so on. I know this is simple but I can't seem to get it right so
it goes down the column. Thank you for any help you can give me.

--
pcscsr
------------------------------------------------------------------------
pcscsr's Profile: http://www.excelforum.com/member.php...o&userid=12006
View this thread: http://www.excelforum.com/showthread...hreadid=276049

--

Dave Peterson