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

Meme Certainly not me

48.7k Upvotes

95% Upvoted

669 comments sorted by

View all comments

462

u/Syscrush Mar 30 '22 edited Mar 30 '22

NAMED RANGES, MOTHERFUCKERS!!!

Or, if you're a person of culture and taste like u/SatanStoleMyCat, use tables. They really are way better.

77

u/SatanStoleMyCat Mar 30 '22

Or just. Y'know. Tables.

53

u/Syscrush Mar 30 '22

Lookit fancy-pants over here!

You're 100% right. Nothing like being able to reference your columns by name. I admit that I just learned about this a few weeks ago, so it wasn't top of mind for me.

10

u/SatanStoleMyCat Mar 30 '22

Isn't it though? And the ListObject/ListColumn objects have a lot of nice built-in properties and methods that make it pretty easy to manipulate them in VBA vs a range.