custom Ribbon

My Custom Ribbon using Formulas to Create XML code

Formulas, Ribbon Customization, Uncategorized

Update 11/08/21 I received an email from Clem who has written an awesome Add-In called Ribbon Icons which looks like below, to address the painful process I whinge about below for choosing and adding icons to your custom ribbon. I just can’t believe someone has nailed the solution to this horrible process a) you can …

My Custom Ribbon using Formulas to Create XML code Read More »

VBA code to check range for specific characters

Data Cleaning, Find & Select, VBA

Update 11/08/21 Well two interesting recent developments have occurred regarding this post on VBA code to check range for specific characters. Microsoft MVP Rick Rothstein kindly contacted me about much more elegant code than I have below, trying to assign 6 table columns to a range variable so the macro would operate on selected table …

VBA code to check range for specific characters Read More »