Published on August 30, 2017 at 07:00AM
Often you don't want to wrap an IF statement when you just want to turn a 0 result into another value such as blank
Published on August 24, 2017 at 06:20AM
Backup all the VBA codes to Git
Published on June 19, 2017 at 01:31AM
Copy this to your PERSONAL.XLSB to quickly switch between Worksheets on the ActiveWorkbook
Published on May 04, 2017 at 06:50AM
Useful to have as a button or invoke overtime to alert when you have forgotten to save
Published on February 15, 2017 at 05:59AM
A basic module I load to each project for shared functionality
Published on February 13, 2017 at 10:54AM
A simple function to return the row number of a table where a value is matched in a column. Like a VLOOKUP or INDEX MATCH for VBA.
Published on May 18, 2017 at 05:32AM
A short introduction to VBA by building something simple
Published on May 13, 2017 at 01:55PM
Go under the Excel hood by getting to know the Visual Basic Editor. The power house of the Excel workbook.