4 ms·
Named 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 nam
by cm2187 3y ago
Named 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)