Turn formula into vba
 

I have a formula that i need to turn into vba
=C41*E41/360

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200611/1

Turn formula into vba
 

try

Range("A1").formula = "=C41*E41/360"

--


Gary


"jln via OfficeKB.com" <u25956@uwe wrote in message news:68fc0f41da24d@uwe...
I have a formula that i need to turn into vba
=C41*E41/360

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200611/1

Turn formula into vba
 

jln via OfficeKB.com wrote:
I have a formula that i need to turn into vba
=C41*E41/360

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200611/1

Assume the range you want the formula in is A41

Range("A41")="=(C41*E41)/360)"

Rgds
Raymond

Turn formula into vba
 

If you are looking to just have the result of the formula in the cell
then...

Sub SortSheet()
Dim MyAnswer As String
MyAnswer = (Range("C41").Value * Range("E41").Value) / 360
Range("F41").Value = MyAnswer 'or whatever cell you'd like
'your answer in.

End Sub


jln via OfficeKB.com wrote:
I have a formula that i need to turn into vba
=C41*E41/360

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200611/1