Skip to content

How To Excel At Excel

Search
  • Blog
  • Formula Friday
  • Macro Mondays
  • Formulas
  • Excel Tips& Tricks
  • Excel Charting

Category: Macro Mondays

link to Macro Monday – VBA ActiveWorkbook vs ThisWorkbook

Macro Monday – VBA ActiveWorkbook vs ThisWorkbook

Hello Excellers and welcome back to another blog post in my #macromondays series.  Today I want to go back to Excel Macro basics for a short time and discuss the fundamental and important...

Continue Reading
link to Create User Defined Function (UDF) And Excel Add-In To Count Cells By Their Colour – Macro Monday

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...

Continue Reading
link to Macro Monday – A Macro To Sort your Excel Sheets Alphabetically By Name

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...

Continue Reading
link to Macro Monday – How To Automatically Lock A Cell After A Value Is Entered

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...

Continue Reading
link to Excel Macro Monday – Watch Excel Record Your Macro In Real Time

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...

Continue Reading
link to Macro Mondays -Creating and Updating Your Personal Macro Workbook

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...

Continue Reading
« PREV Page 1 … Page 22 Page 23 Page 24 Page 25 Page 26 … Page 33 NEXT »

© 2025 Copyright How To Excel At Excel