Simple Custom Function???

[Guest]

I'm trying to create a simple custom function. I'm trying to have the user
input the row and column numbers in the function (like =MYFUN(1,2)
referencing cell B1) and have it return the contents of that cell. So I
thought I would use the following.

Function MYFUN(varA, varB)
MYFUN = WorksheetFunction.Indirect(Address(varA, varB))
End Function

So then I tried simplifying it with just
MYFUN = WorksheetFunction.Address(varA, varB)
thinking it would return $B$1 but nothing.

What am I doing wrong?

 

[Guest]

Public Function MyFunc(ByVal RowNum As Long, _
ByVal ColumnNum As Long) As Variant
MyFunc = Cells(RowNum, ColumnNum).Value
End Function