Simple Custom Function???
Thank you!
"Jim Thomlinson" wrote:
Public Function MyFunc(ByVal RowNum As Long, _
ByVal ColumnNum As Long) As Variant
MyFunc = Cells(RowNum, ColumnNum).Value
End Function
--
HTH...
Jim Thomlinson
"Mike" wrote:
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?
|