Hello and welcome to yet another #formulafriday blog post. I want to share today with you an Excel formula problem a colleague of mine asked me to look at a week or so ago. So, I thought it would...
Posts by Barbara
Create User Defined Function (UDF) And Excel Add-In To Count Cells By Their Colour – Macro Monday
Hello Excellers and welcome back to another #macromonday. Creating your own Excel VBA function can be very useful. Don't get me wrong most of our calculations needs can be achieved with what is...
Macro Monday – A Macro To Sort your Excel Sheets Alphabetically By Name
Hello Excellers, I am happy to bring you another Excel Macro Tip today in the #macromonday blog post series. This macro is one that I use a lot at work - Sorting my Excel sheets alphabetically by...
Macro Monday – How To Automatically Lock A Cell After A Value Is Entered
Welcome to another #macromonday blog post in this series. This blog post is in answer to a question sent to me by a subscriber. They wanted to know how to lock a cell once there was a value...
Excel Macro Monday – Watch Excel Record Your Macro In Real Time
Hello Excellers and welcome to another blog post in my #macromonday series. This is the place where we discuss all things Excel macro and Excel VBA. Today I want to share with you real-time VBA...
Macro Mondays -Creating and Updating Your Personal Macro Workbook
Hello Excellers, welcome to another #macromonday blog in this series. Today let's look at saving macros to a personal macro workbook to reuse in any workbook when you start Excel on your...