I need a selfwritten function that uses the value of row 2 in the column of the actual cell.
I know I can use Application.ThisCell.Address to find the complete address, and then I get for instance $K$13 or $L$14 or something else, but I need the content of cell K2 (or L2 in case the actual cell is Lxx (where xx can be any value).
So:
Function MyFunction()
MyFunction = Application.ThisCell.Address
End Function
And, for instance in K14: =MyFunction() gives as a result $K$14, but I need $K$2
And in K7: =MyFunction() gives as a result $K$7, but I need $K$2
So I need always row 2
Bookmarks