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 – An Easy Excel Macro To Hide All But Your Active Worksheet
Hello Excellers. Welcome to #macromonday in my #Excel series. Are you working on a project with multiple worksheets and want to keep the audience focused on the one-sheet you're...
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....
Welcome back, Excellers. Welcome to another #MacroMonday in my Excel series. As an Excel user, you may be wondering how to prevent other users from printing your workbook. This can be a helpful...