VBA

Macro to fix Duplicated Conditional Formatting rules in Tables

Note this only works for Tables.  One day I will adapt this code for a 2nd macro to work with a specified range. 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

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

Use the macro recorder for VBA code for a relative formula

I did this very thing today, so thought I would share this tip with you as it saved me a lot of time.   Say you wanted to have this formula go into column 8 of the range you created in VBA for the number of dynamic rows you extracted using Advanced Filter. =CHOOSE( OR(C6={“EL”,”IL”})*1+(C6=”MT”)*2+OR(C6={“IP”,”EP”})*3+(C6=”SC”)*4+(C6=”AD”)*5, “Labour”,”Materials”,”Plant”,”SubContract”,”Overheads”)

Use the macro recorder for VBA code for a relative formula Read More »