8 ms·
Agreed! Hard cell references should rarely be used. Names for metadata variables (eg. Current_Month) and tables for datasets.
by steine65 2y ago
Agreed! Hard cell references should rarely be used. Names for metadata variables (eg. Current_Month) and tables for datasets.
- tichiian 2y agoYes. 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.