J
Jeff
Hi,
I wrote the following code to calculate IRR.
Sub IRR()
Dim X As String
X = Range("F9").Value
Range("H9").GoalSeek Goal:=X, ChangingCell:=Range("F4")
End Sub
This works fine alone, but when I put it in a Command Button and use:
Call IRR
I get the following error:
"GoalSeek Method of Range Class Failed"
Does anyone know what the problem is?
Thanks
I wrote the following code to calculate IRR.
Sub IRR()
Dim X As String
X = Range("F9").Value
Range("H9").GoalSeek Goal:=X, ChangingCell:=Range("F4")
End Sub
This works fine alone, but when I put it in a Command Button and use:
Call IRR
I get the following error:
"GoalSeek Method of Range Class Failed"
Does anyone know what the problem is?
Thanks