Using Advanced Filter to Copy Unique Values via VBA

I recently had to create a workbook for a client whereby a User facing worksheet had data validation cells that needed to be dynamically updated based on a prior selection.  To do this I thought I would try using Excel’s Advanced Filtering function.  The source data was in a Table, and I thought it would […]

View Details

Trapping Application events in Excel

To be able to trap application events across all open workbooks in MS Excel via an add-in follow these steps. Add a class module In the class module enter the following at the top of the module Public WithEvents xlApp as Application Then you will be able to write code within any of the application […]

View Details