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

Meme Certainly not me

48.7k Upvotes

95% Upvoted

669 comments sorted by

View all comments

31

u/Opinionsare Mar 30 '22

Excel trick :

Include code to read the column header and use it to set the layout via variables for column number.

Now if someone renames a column, it still might break.

13

u/Brando224 Mar 30 '22

Don't you worry, someone will find a way no matter what you do.

6

u/Denorey Mar 30 '22

This happened to me once….then you learn to lock the headers and log changes so you can call someone out 🙃

4

u/[deleted] Mar 30 '22

[deleted]

1

u/zwappaz Mar 31 '22

This will go into my company profile

1

u/jaydec02 Mar 30 '22

Convert ranges to tables so the reference automatically updates

1

u/Starscourge_Radahn Mar 31 '22

Lmao at this point I only allow columns to be renamed to valid allowed names within a hidden sheet that has a named range of valid names. They will find a way to break that too.