| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you turn off the formula bar? | New Users to Excel | |||
| Want formula to turn to value by itself | Excel Discussion (Misc queries) | |||
| Turn Off Formula ? | New Users to Excel | |||
| How to turn a string into a formula? | Excel Programming | |||
| Turn OFF Formula Bar??? | Excel Programming | |||
Hybrid Mode
