Articles

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 »

Ever wanted to list all the tabs in a workbook or reference a specific sheet by its placing, look no further..... This funky little custom VBA function can be used simply as a contents sheet, This is a particularily useful tool tool when used with the indirect function, it will allow you to soft-link to any cell within your worksheet. There are a   more »