3 ms·
Good excel (such a thing does exist) should almost never refer to a cell by its coordinate rather than using either a named range or better still a table, this
by mhh__ 3y ago
Good excel (such a thing does exist) should almost never refer to a cell by its coordinate rather than using either a named range or better still a table, this probably encourages not doing that.
- cm2187 3y agoNamed ranges are evil except in a limited number of cases (referring to a cell from VBA). If you duplicate a tab or move it to another workbook and you have named ranges, hell starts there.
- mhh__ 3y agoTrue of variables in most languages, are they evil too?
- cm2187 3y agoIn the languages where all variables are global variables, they are.
- hannofcart 3y agoAlso, I find that named ranges seem to slow down the Excel file when the number of rows get a bit large (100k or so)