| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simple problem, simple formula, no FUNCTION ! | Excel Worksheet Functions | |||
| How to create a simple VBA Custom Function | Excel Programming | |||
| Insert function - custom function name preceded by module name | Excel Programming | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
| Adding a custom function to the default excel function list | Excel Programming | |||
Hybrid Mode
