Hi, Excellers welcome again to my #formulafriday blog post series. Today I want to share with you a great little hack for your chart axis labels. If you find yourself with a shortage of real...
Category: Blog
How To Use The VBA BeforeClose Event To Remind Users To Backup Their File – Macro Monday
Hello fellow Excellers and yes it is #MacroMonday time again. Time for some cool Macro fun. Today let's look at the VBA BeforeClose event for a workbook. This event occurs before the workbook...
Highlight Weekend Dates In Your Data Set. Conditional Formatting Using A Formula – Formula Friday
Hello Excellers and welcome to another #formulafriday blog post. Today let's take a look at using conditional formatting along with an Excel formula to highlight dates in our data set that fall on a...
Create A Macro To Calculate Only Selected Cells In An Excel Worksheet – Macro Monday
Hello Excellers, its Monday again and that means time for some more #macromondayfun. Today I want to share with you a useful macro which allows the user to calculate only selected cells in an...
If you have been using Excel for a while you probably have used, or have been sent a spreadsheet with at least one hyperlink in them. These work really well until the order of sheets is changed,...
One Line Of VBA To Rename Worksheets In Excel Workbooks – Macro Monday
Hello Excellers and welcome to another #macromonday blog post. Today I want to share with you a little VBA code that will speed how you rename worksheets in your Excel workbooks. In particular,...