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...
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...
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...
Macro Monday – Insert A Page Break After Specified Number Of Rows with VBA
Hey Excellers, it is indeed time for some more #macromonday fun. Today's Macro will insert a page break in our Excel sheet after a specified number of rows. This is a piece of code I used...
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...