Correcting Shape Assigned Macro Links After Copying Worksheet VBA

Correcting Shape Assigned Macro Links After Copying Worksheet VBA

The easiest way to copy over VBA code while copying your worksheets into a new workbook is to store your VBA macros within the worksheet itself instead of the typical Modules that most people use. While it is possible to copy Modules from one workbook to another, it adds another layer of VBA coding that is much more of a hassle than storing your code within a Worksheet Object.

Read More

Adding Tickmark Indicators To Your Excel Analysis Comments

Adding Tickmark Indicators To Your Excel Analysis Comments

Today, I am going to show you how to easily add indicators to your commentary so your audience (ie the decision-makers) already has the right state of mind before reading a single letter of your comments. This will tremendously help them comprehend your analysis and score you "brownie points", because they will be able to do it in a fraction of the time as well!

Read More

Using Cell Formatting Logic With Excel Formulas

Using Cell Formatting Logic With Excel Formulas

Have you ever had a time where you wished you could write an IF formula in Excel based on whether or not a cell was filled with the color green or not? Unfortunately, Excel doesn't have a built-in "IsGreen" function you can call to perform such logic. However, with the power of VBA you can write your own functions and actually call them from the Formula Bar! 

Read More