I often upgrade the readability of formulas by naming a column (technically as a range) and replacing e.g. =D2 by =Status relying on Excel interpreting the range name as a reference to the current row in that range. (Sad though that formula editing's source highlighting doesn't do the same, instead showing highlighting range rather than cell.)



However, replacing =myfunc(D2) by =myfunc(Status) can (depending on myfunc definition) fail with a VALUE error. It seems the interpretation is AWOL.

My workaround is: =myfunc(INDEX(Status,ROW())) . This defeats much of the readability upgrade.

Do you know a workaround that's more readable?

The best I've come up with is a user function - here(<name>) - which is a lot more elaborate in definition and a lot slower in execution.