Blog


An enhanced name manager for Microsoft Excel

An enhanced name manager for Microsoft ExcelNamed 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   more »



Excel function to list worksheet names

Excel function to list worksheet namesEver 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 »



Share page

Subscribe to newsletter

Search Posts

Back to top