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 all of their hyperlinks. They had a worksheet with 50+ tabs and hyperlinks on all of them. The usual method of deleting hyperlinks was not working select the cells that contain the hyperlinks Right Click Delete Hyperlinks You would expect maybe to be able to simply group all of your worksheets and … [Read more...]
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 subscriber could not find or locate any Macros they had stored in their Personal Macro Workbook. Where had ALL that work gone?. Where were the missing macros?. They were freaking out. (Of Course!). Their Personal Macro Workbook was missing. The Personal Macro Workbook was not showing up in the … [Read more...]
Macro Mondays – Renaming An Excel Macro.
Hello Excellers. Welcome to #MacroMonday again. Today let's take a look at how to rename an Excel Macro. For some reason, you may find yourself having to rename one of your Excel Macros that you have already created. It is quick and easy to do. If you want more Excel and VBA tips then sign up to my monthly Newsletter where I share 3 Excel Tips on the first Wednesday of the month and receive my free Ebook, 30 Excel Tips. How To Excel At Excel – Macro Mondays Blog Posts. How To Rename An … [Read more...]
Macro Mondays – Running An Excel Macro From The Immediate Window
Hello Excellers welcome to another #MacroMonday #Excel blog post in my 2020 Excel Macro series. Today let's take a look at using the Immediate Window in the Excel VBA debugging environment. This environment can be used as a type of scratchpad or sandbox areas and has many uses as well as debugging code. If you cannot see the Immediate Window, you just need to enable it. It really simple. Open the Visual Basic Editor View Immediate Window Or if you are mad for shortcuts, then you can do the … [Read more...]
Insert Multiple Rows Into Excel. Macro Solution.
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 rows to insert via an input box. This is a really flexible alternative solution to inserting a standard number of rows after each data containing data in Excel. So, it puts the user in full control of where and how many black rows to insert. Preparing To Write The Macro First, you … [Read more...]
- 1
- 2
- 3
- …
- 31
- Next Page »
Recommended Excel Resources
