Hi,
I'm trying to write a function that should search for a value in the first cell of the row in which the function is called,
so to clarify:
CELL G12: =FINDTEAMS() --> This is a public function I defined
I'd like to be able to refer to CELL A12 in the public function, but without using the ActiveCell reference.
The reason behind it is that I want to be able to update all the Cells in column G with formula =FINDTEAMS(),
and when you do so, the ActiveCell doesn't change, always refers to original cell.
I also want to indicate that I don't want to reference the current cell in the formula: =FINDTEAMS(G12),
this to reduce the risk of human error.
Any help would be greatly appreciated.
Bookmarks