Hi,
I have a function where I wish to define according to content entered into a cell. In its current form, the function is as the follows i.e.
Public Function f1xy(x, y)
f1xy = y - y ^ 2
End Function
Where as i wish for it to be
Public Function f1xy(x, y)
f1xy = ActiveSheet.Range("F3").Formula
End Function
where cell F3 contains y-y^2 as text. Of course this didn't work
I've tried:
Public Function Formula()
Formula = ActiveSheet.Range("F3").Formula
End Function
Public Function f1xy(x, y)
f1xy = Evaluate(Formula)
End Function
This doesn't work either. Any help will be greatly appreciated
I have a function where I wish to define according to content entered into a cell. In its current form, the function is as the follows i.e.
Public Function f1xy(x, y)
f1xy = y - y ^ 2
End Function
Where as i wish for it to be
Public Function f1xy(x, y)
f1xy = ActiveSheet.Range("F3").Formula
End Function
where cell F3 contains y-y^2 as text. Of course this didn't work
I've tried:
Public Function Formula()
Formula = ActiveSheet.Range("F3").Formula
End Function
Public Function f1xy(x, y)
f1xy = Evaluate(Formula)
End Function
This doesn't work either. Any help will be greatly appreciated