October 12, 2015
Want to generate a Table of Contents or an Index as some may call it in your Excel workbook?
June 24, 2015
Use the below code to Call an SQL Stored Procedure With 2 Parameters.
All you have to change is the...
February 12, 2015
If you have a workbook with many hidden worksheets, you cannot unhide all of them at once, UNLESS, y...
Slicers were a great introduction in the Excel 2010 Version. They work really really well with Pivot...
January 11, 2015
The following code will generate a Transparent Rectangle with Red Border on the Active Cell, when ex...
December 27, 2014
To work with the Macro Recorder or VBA (Visual Basic For Applications) you need to enable the Devel...