Sum Cumulatively Across Rows or Down Columns Of Data – Formula Friday
Hello Excellers and welcome back to another #formulafriday blog. Today's tip was a question from a colleague. Thye wanted to know how to calculate a cumulative or running total in your Excel...
Set Up A Dynamic Print Area In Your Excel Worksheet – Using A Small VBA Macro
Hello Excellers, welcome to another #macromondays blog post. I have a really nice little bit of VBA code for you today which allow you to set your Print area in your Excel worksheet to become...
Calculate How Long A Task Will Take Using CONVERT Function – Formula Friday
Hello Excellers, time for some more Excel formula fun on a Friday. What could be better?. In today's blog post let's look at a really handy Excel formula to help us to easily calculate how long...
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...