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...]
Excel VBA Macro Code To Select Current Region In Excel.
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 Macro. So, what is the Current Region on an Excel worksheet?. What Is The Current Region? The current region is a range of cells bounded by and combination of blank rows or blank columns. Let's take a look at some examples to explain, and see how this is really useful when we are writing … [Read more...]
Insert Blank Rows In Excel Macro.
Need to now how to insert blank rows in Excel?. Hello Excellers and welcome back to another #MacroMonday #Excel blog post in my 2020 series. Today's blog post is an alternative macro or VBA solution to a very popular YouTube video I have already published. It is a very common question. Just how to do I insert blank rows between existing rows in Excel?. The link to a non VBA or Macro solution to this problem can be seen … [Read more...]
Formula Friday – 3 Ways To Protect Your Excel Formulas
Hi Excellers, this is a different #formulafriday in my Excel 2020 series. I want to share with you 3 ways to protect your Excel formulas. So, you have spent a long time preparing your Excel spreadsheet solution, and I bet you don't want anyone to mess up it up. So there are a few ways to protect some of those most vulnerable parts of your Excel spreadsheet. Here are my top 3 ways to protect your Excel Formulas!! Hide them Lock Cells Hide The Formula Bar With Some Simple VBA. 1.Hide … [Read more...]
Remove Page Breaks With A Quick Excel VBA Macro – Macro Mondays
Hello Excellers, time for a quick bit of Excel Macro VBA coding on a Monday. What could be better?. It is time to get Excel to all the hard work for us if we can right?. Today I will help you remove those annoying page breaks in Excel. You know the ones that insist on staying around even when you have navigated from the Page Break Preview back to Normal View. Now as annoying these are, you can get rid of them with the following process- File | Options | Advanced Display Options For … [Read more...]
- 1
- 2
- 3
- …
- 42
- Next Page »
Recommended Excel Resources
