Category: Macros

For those new to workbooks with macros

If you are new to workbooks with macros here is a short 2 min video on the quick setup needed to work with them on your PC’s Excel and some basic points to be aware of…  

Tagged with:

Macro to fix Duplicate Conditional Formatting rules in Tables

Following on from my recent post of Fix duplicated Conditional Formatting Rules , I mentioned Debra Dalgaleish’s website page had some great VBA to fix duplicated and messy Conditional Formatting.  I tweeked this code just a bit so that all

Tagged with: , , , , ,

Autocomplete Workaround for Validation Dropdowns

As might know there is no autocomplete functionality with Data Validation dropdowns.  I wonder if the Microsoft development teams are considering this as it would be a wonderful feature.  I sometimes wonder if the validation dropdown was an accidental dropdown

Tagged with: , , , , ,

Personal Macros – Personal.xlsb or Add-In.xlam?

My last blog was on accessing personal macros from my custom ribbon. This blog is about where to store these personal macros.  These personal macros are the ones that save you time and tedious work.  There are basically two ways

Tagged with: ,

VBA to Change Pivot Table Source

I recently worked on a project that had three distinct and large datasets for different geographical areas in three workbooks.  Starting with the first workbook and dataset in a Table in its own worksheet, I created a worksheet of seven

Tagged with: , , ,

Tip for creating syntax in VBA for Worksheet formulas

I monitor many Excel and VBA blogs using Feedly and see all sorts of tips, code and great solutions to collect and learn from along the way.  There is no better site for VBA than Anyone who has used

Tagged with: , , , ,

Grabbing messy data with VBA Arrays

This post is about a common business problem of grabbing messy data from a transactional document and updating a dataset to collect history.  In my previous life, I was in Commodity Export Marketing, so I am using the ‘real world’

Tagged with: , , , , ,

Personal Macros – SelectAllFormulas

I thought I would blog some handy personal macros I use day to day.  This is the first and I will do others. This one simply needs to select all formulas (so I called it SelectAllFormulas) the worksheet using the

Tagged with: , , , , , , ,

Exporting to PDF

Had a small, interesting job last week where the client had an .xlt template with existing in-house VBA to let the user save certifying documents within the an .xls file to a default folder plus “print to pdf” ie creating

Tagged with: , , ,