I use named ranges a lot both to identify particular ranges on a sheet, and as markers to identify certain properties of a sheet so that when an auto command happens, it can tailor what it does for the sheet.
I have got to the stage whereby I cannot rely on a range - or individual cell - not...