View Single Post
 
Old 09-15-2025, 03:26 AM
chrisjj chrisjj is offline Windows 7 64bit Office 97-2003
Competent Performer
 
Join Date: Aug 2025
Posts: 120
chrisjj is on a distinguished road
Default Excel 2003 formulas - Is there a more-readable way to use names in place of literal cell references?

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.
Reply With Quote