This is another handy personal macro I use in my day to day spreadsheeting and application building. It sits in my Add-In which has it’s own tab on my custom ribbon, but you might just use the ribbon QAT or a personal.xlsb file for these kind of personal efficiency macros. I did a post […]
Personal Macros – Locked & Unlocked cells Read More »
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 to go. Some save them to their Personal.xlsb file that loads on opening Excel. Others
Personal Macros – Personal.xlsb or Add-In.xlam? Read More »
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 is a macro to select all formulas (so I called it SelectAllFormulas) on the worksheet using the SpecialCells method. Nothing hard in this and I used the macro recorder
Macro to Select All Formulas Read More »