Named ranges are one of those marmite things in Excel, either you use them or you don't. I sit between the two camps and my utilisation depends on two things: Firstly who the end user will be and whether they'll need to interact with them. The other is a timesaving thing - their use will depend on if it will save me time over the long run. My more »