Mx9 Sheets Add-In
A FREE Excel utility to easily manage your worksheet tabs – hide/unhide/reorder in one simple-to-use interface
Dev Corner
Dev Corner: Code Snippets and Dev Modules This section contains lots of useful tools for Office VBA developers – there are plenty of VBA snippets to cut and paste into your own projects, plus some useful modules and forms that you may want to add to your own...XLT Code Main Page
Excel Tables | VBA Code If you work with structured data in Excel, then you likely use Excel tables (known as ListObjects in VBA). This section contains various code snippets that we use here at Matrix9 to make our life easier when dealing with these tables in our...XLT Get Column Number
Used to get the column number of a column in an Excel table, based on the column header’s name
XLT Get Table
When working with Excel tables in VBA, this simple code to gets an Excel table in a workbook and sets it as a variable, without needing to reference sheet names.