CHOOSE

Check range for specific characters – Customizing the Ribbon

Update 11/08/21 Well two interesting recent developments have occurred regarding this post! 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 columns (not all). So I have just the relevent …

Check range for specific characters – Customizing the Ribbon Read More »

Avoiding Nested IFs

We have all done them but there comes a time to find a better way.  In Excel 2003 you were limited to 7 levels of nesting but 2007 onwards the level could be increased to 64. Both these levels are beyond my pain barrier for an overly complex formula fraught with danger. Even if you …

Avoiding Nested IFs Read More »