M
Mike
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?
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?