Simple Custom Function???

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?
 
J

Jim Thomlinson

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top