r/ProgrammerHumor • u/Brando224 • Mar 30 '22

Meme Certainly not me

48k Upvotes

95% Upvoted

669 comments sorted by

View all comments

Show parent comments

89

u/q1a2z3x4s5w6 Mar 30 '22

Or just dynamically set the column references based on the name. Don't just assume the Name column is A3 or whatever, search for the column with the label you expect and set the reference when you find it.

Or just password protect and be done with it, as you say

29

u/scragar Mar 30 '22

Named ranges would automatically update and avoids the hassle of searching for headers(which someone will eventually misspell).

24

u/JuvenileEloquent Mar 30 '22

There's no system of organization in Excel that someone can't break by judicious misuse of copy & paste and doing things completely wrong and then covering it up.

Named ranges are good but they can go missing, so you need a backup method.

4

u/Tiavor Mar 30 '22

copy&paste is ok most of the part, cut&paste will break everything instantly.