Macro Mondays – How To Write A Macro To Delete Rows If A Cell Is Blank
Hello Excellers. If you're an Excel user, you know that one of the most tedious tasks is deleting rows if a cell is blank. Well, worry no more! With a simple macro, you can delete any number of...
Macro Mondays – Remove Personal Information From Excel Using Some Simple VBA
Hi Excellers, welcome again to some more #macromonday fun. Do you need to share your Excel workbooks?. Do you need to hide the personal information attached to those workbooks.? Well, it is easy to...
Hello, Excellers. Welcome to another Excel Tips blog post in my 2021 series. I will show you a simple Excel trick to open a new version or copy your Excel workbook. Preventing any issues if...
Formula Friday – Is That Odd? Testing A Number With ISODD Function.
Hello Excellers, and welcome back to another #FormulaFriday #Excel blog post in my 2020 Excel series. I kind of like odd things. Always have done, even this Function looks odd don't you think?. ...
How To Find The Minimum Number In A Excel Data Set – Two Formula Options – Formula Friday
Hello Excellers and welcome to my regular blog spot of #formulafriday. Today is really a double edition as I show you two great ways to find the minimum number in an Excel data set using two Excel...
Formula Friday – 2 Ways To Create A Dynamic Named Range In Excel
Time for some more #formulafriday fun. Today let's look at 2 ways to create a name range in Excel. If you want to read more about using named ranges in your Excel formulas then you can read my...