Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello.
I am tring to write a function that I would call from many different sheets and cells in a workbook. The answer that the function returns is relative to the location of the cell containing the function call. I was thinking that I need to pass the row and column of the call, like this: =NextTaskDueDate(ROW(FG69),COLUMN(FG69)) This works well and gives the correct result. However, I also need to pass in the name of the sheet, because I make the function call from within many different sheets. Is there a way to create a 3rd parameter, which is the name of the worksheet holding the cell containing function call? Or, even better, is there a more effective way of identifying, within the code within the receiving function, the location (sheet and cell reference) of the function call? Thanks. Keith |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to call a worksheet (as a function) | Excel Discussion (Misc queries) | |||
how to make sure which worksheet call the function | Excel Programming | |||
can I call a worksheet function from within vba? | Excel Programming | |||
identifying which cell calls my VBA function. | Excel Programming | |||
Identifying cell from which a call is made | Excel Programming |