Hacker News new | ask | show | jobs
by steine65 766 days ago
Agreed! Hard cell references should rarely be used. Names for metadata variables (eg. Current_Month) and tables for datasets.
1 comments

Yes. But many parts of excel don't support those. E.g. conditional formatting just doesn't deal with names.

Also, when you need names, it is a sign to reach for a proper programming enviroment like Delphi or Lazarus.