Hacker News Reader

Agreed! Hard cell references should rarely be used. Names for metadata variables (eg. Current_Month) and tables for datasets.

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.