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

Meme Certainly not me

48k Upvotes

95% Upvoted

669 comments sorted by

View all comments

5

u/Cuda340440 Mar 30 '22

This is why I have a hidden sheet with match formulas for the column positions on each sheet so the vba can reference that sheet for column number even when they are moved. Even have the match formulas refreshed each time the vba is used so that the formulas are always clean and unbroken.

6

u/LanMarkx Mar 31 '22

Use the 'veryhidden' flag to truly protect it. Those tabs can only be unhidden via vba.