I've thought that before but every time I've named important ranges I've come to regret it. Someone at some time will decide to nuke an entire worksheet and pa

I've thought that before but every time I've named important ranges I've come to regret it. Someone at some time will decide to nuke an entire worksheet and paste it back in without the named ranges, and then everything will look the same but various lookups and macros will break. (And they will somehow be able to do this even though you've password-protected everything in sight, too. Not sure how that happened.) Or someone will insert a row somewhere and the named ranges will be missing the last row of the data and any named ranges beneath them won't shift down. That kind of thing. Maybe I'm just missing some named range best practices.