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...]
Macro Mondays – Commenting Out A Block Of Excel VBA Code.
Hello, Excellers. Welcome if you are new to my Excel Blog and welcome back if you are a regular reader. So, today I will show you how to comment out a block of Excel VBA Code. Or in other words, make comments on the lines of code in your Excel macro. Why Make Comments In Excel VBA Code. First, let's look at why you would make comments in your VBA code. Why not just write the code and let it be?. There a few reasons that it is considered best practice to write comments in your VBA … [Read more...]
Macro Mondays – Convert A Range OF Cells To ‘Proper’ Case With An Excel Macro
Hi Excellers, and welcome back to another #MacroMonday #Excel blog post in my 2020 macro series. It is time to sit up. We will be using the Proper Function today!. You may (or may not) know that you can change the case of text using the Excel PROPER function. What the heck does that mean?. Well, say you have text like this. I lOVE eXcel. If you apply the PROPER formula to this cell, Excel will happily convert your text string to 'I Love Excel'. This is converted to the correct case for … [Read more...]
Formula Friday – Count How Many Numbers In A List Are Greater Than The Average Using The COUNTIF Function.
Hello Excellers and welcome back another #FormulaFriday #Excel blog post in my 2020 Excel series. I will share a solution to a question asked recently. How to find how many numbers in your list are greater than the average. This is a useful formula solution using the COUNTIF Function. It can be used to answer a number of questions such as HOW MANY? students scored higher than average employees are paid higher than the average sales reps made sales higher than the average The … [Read more...]
Macro Mondays – Using An Input Box To Determine Which Excel Rows To Delete.
Hello, Excellers and welcome back. It is time for another installment in my #MacroMonday #Excel blog posts in my Excel 2o20 series. This macro, using an input box, really is a time saver and once used, it is never tucked far away from me in my Excel and Macro toolbox. I am going to show you how to delete rows in your Excel worksheet. However, instead of having the parameters that determine which rows to delete 'hard-coded' into your Macro, I will be using an input box that allows the user to … [Read more...]
- 1
- 2
- 3
- …
- 42
- Next Page »
Recommended Excel Resources
