Hello, Excellers. Welcome back to another #MacroMonday Excel tips blog post in my #Excel series. Are you an Excel user who creates macros and VBA code? If so, it's essential to...
Tag: VBA
Macro Mondays – Delete Excel Rows That Do Not Contain Specified String
Time for some more Macro Fun on #macromondays. Do you have a worksheet with data that needs cleaning? Maybe there are some rows that you don't need. Perhaps you want to delete all...
Macro Mondays – Convert A Range Of Cells To Lower Case With An Excel Macro
Hello, Excellers. Time for some more #Macro fun. If you've ever needed to convert a range of cells in Excel to lowercase, you're in luck!. In this post, I show you how to create a macro...
Macro Mondays – How To Assign An Excel Macro To A Button Or Assign A Button To An Excel Macro
Hello, Excellers Welcome back to another #Excel blog post in my #MacroMonday #Excel series. I want to show you how to assign an Excel Macro to a button or assign a button to an Excel Macro,...
Macro Mondays -Using An Input Box To Determine Which Excel Rows To Delete.
Hello Excellers, and welcome back. It is time for another instalment in my #MacroMonday, #Excel blog posts in my Excel series. This Macro demonstrates how to use a VBA input box to determine which...
Macro Mondays – Write A Macro To Display A Progress Message In The Status Bar
Hello, Excellers. Bit of a fun Macro today, which is also very useful. If you've ever written a macro in Excel, you know there's no built-in way to display a progress message in the status bar....