Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can a VB function determine the cell within which it is runnin
I currently have a VB function that takes a string argument and a column
number argument. It scans a key column for the string (using the MATCH worksheet function) and returns the the value at column number in the matched row: =kval("XXXXX", COLUMN(E1)) for example, to get the cell value from column E of the row that contains "XXXXX" in the key column. Frequently, I use the function to return a value from the same column that the function reference is in: =kval("XXXXX", COLUMN()) I would like to be able to compute the value that COLUMN() (or ROW()) would supply within the function itself. How can I do this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function to determine if a cell contains a formula | Excel Discussion (Misc queries) | |||
Function to determine whether cell contains a formula? | Excel Worksheet Functions | |||
Value of cell to determine range in MAX Function | Excel Worksheet Functions | |||
Is there a way to determine which cell the function =min() used? | Excel Worksheet Functions | |||
Is there a function to determine whether a cell contains a formul. | Excel Worksheet Functions |