Macro Mondays – How To Store The Current Range Selection With VBA In Excel.
It's #MacroMonday again This blog post will show you how to store the current range selection with VBA in Excel. This is a very useful way to select all the cells that are contained within a Range...
Hi Excellers, welcome back to another #Excel tip. Did you know that you can automatically add new items to a drop-down list in Excel? It's a great way to keep your list of options up to...
Hello Excellers time for some more #macromonday fun. If you use Microsoft Excel, then you know that organiSing your data is a critical part of the spreadsheet process. And one of the most efficient...
Macro Mondays – Save An Excel Workbook When A Specific Cell Or Cells Change
Hello Excellers, welcome to another blog post in my #MacroMonday series. Today let's look at getting Excel to save our workbook as soon as a specific cell or range of cells is changed by a...
Formula Friday – Use The Search Function To Create A Search Bar In An Excel Cell.
Happy Friday Excellers Welcome to another blog post in my Excel #formulafriday series. . Today let's look at creating a search bar right in an Excel cell in our workbook. Yes, you can use the...
Macro Mondays – An Excel Macro To Count How Many Worksheets (Hidden And Visible) An Excel Workbook
Hello Excellers, time for some more #macromonday fun. I am excited to share with you some more Excel VBA code. Have you ever needed to know how many worksheets are in a workbook, specifically how...