Today I want to share with you a very useful Excel VBA macro. This is a small bit of code that come in useful to easily highlight all cells in your Excel worksheet that have data validation. I...
Category: VBA
Hello Excellers and welcome back to another Excel Macro blog post in my #MacroMonday 2020 series. Today I will walk you through how to write simple Excel VBA macro which will save an Excel file. ...
Macro Mondays – How To Write A Macro To Delete All Hyperlinks In Your Excel Workbook
Hello Excellers, time for some more Excel VBA macro Fun. It is time for another #Excel #macro Monday post in my 2020 series. I want to answer a question from a subscriber. They needed to delete...
Enable Your Personal Macro Workbook. Help! Where Did It Go?.
Hello Excellers and welcome back for another #Excel #MacroMonday blog post in my Excel 2020 series. Today is a quick (ish) macro or VBA tip in response to a question I have been asked recently. A...
Hello, Excellers. Welcome back to another #MacroMonday #Excel blog post in my Excel Macro 2020 Series. Today I will show you how to insert Multiple rows into Excel. The user will specify how many...
Hello Excellers an welcome back to another #MacroMonday #Excel tip in my 2020 series. Today let's take alook at how to select the current region on an Excel worksheet with a simple Excel...