Macros

Macro to fix Duplicated 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 Conditional Formatting rules.  I tweeked this code just a bit so that all you have to do is select anywhere in any Table in the active worksheet and it …

Macro to fix Duplicated Conditional Formatting rules in Tables Read More »

Exporting to PDF

I 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 a pdf file and saving it to a user chosen folder.  It used a …

Exporting to PDF Read More »