Category: Excel VBA


The Unhide Worksheets utility

If you hide sheets in Excel you know how annoying it is to unhide them. Excel can only unhide one at a time!
Download this solution.


Sort Tabs Alphabetically in a Workbook

Some workbooks have lots and lots of tabs. The record I’ve heard was 300!
Learn how to sort your tabs alphabetically to make it easier to find one.


Creating Abbreviations with Excel VBA

A simple VBA procedure that turn an expression into an abbreviation.
Simple example: ‘International Business Machines’ would return IBM.