How To Copy A Variable Sized Range Using VBA – Macro Mondays
Hello Excellers, welcome to another #macromonday. Today let's look at a really useful VBA macro where I will show you how to copy a variable sized range of cells from one workbook to another. I...
Formula Friday – How To Count Formula Errors On An Excel Worksheet
Happy Friday and time for some more #formulafun on a Friday!. I recently was asked to find a way of knowing how many errors ( if any) were in an Excel worksheet. I came across this quick and easy...
How To Delete All Shapes From Your Excel Worksheet With A VBA Macro – Macro Monday
Hi, Excellers welcome to another #MacroMonday blog. Today I want to share with you how to quickly delete any shapes that you have in your Excel workbook. Ok, I hear you say would I really have...
Write A VBA Macro To Display A Pop Up Message When A Specific Sheet Is Activated – Macro Mondays
Hello Excellers. Today let's look at how to write an Excel Macro with some simple VBA to display a pop-up message box when a specific worksheet is activated. This method can be useful if you need...
How To Apply Conditional Formatting To An Excel Pivot Table – Correctly – Excel Tip
This next tip I know causes a bit of frustration with Excel users, based on the number of times I have been asked about it. It is applying conditional formatting to a Pivot Table. The method of...
Pivot Table Tip- Assign The Correct Row And Column Labels Quickly
Hello Excellers, today I want to share with you a really good Excel Pivot Table Tip with you. Do you ever quickly create a Pivot Table, then end up with really naff labels on them. A bit like...