VBA Coding With Shape Objects In this comprehensive guide, you will be learning all the ways you can create and...
What This VBA Code Does If you need to convert Hex color codes into the RGB format, the below macro...
What This VBA Code Does There may be times when you need to incorporate coloring your worksheet tabs in your...
What This VBA Code Does The following line of VBA code will allow you to determine if a spreadsheet cell...
What This VBA Code Does Let’s face it, it’s a real pain to change the colors of borders….especially if they...
What This VBA Code Does I ran into an issue where I needed some of my brand colors to be...
What This VBA Code Does If you have ever formatted VBA userforms, you’ve most likely noticed that the color codes...
What This VBA Code Does If you are a formatting nut like me, you will most likely appreciate an issue...
A Little Background This post shows how you can use VBA code to add specific colors (outside your color theme)...
What This VBA Code Does Lars-Erik reached out to me via Facebook with an interesting code concept that would prevent...
QUESTION How can a find the last cell on a spreadsheet based on a given color? SOLUTION This VBA macro...
What This VBA Code Does Here is a simple VBA macro that will remove any fill colors from your selected...
What This VBA Macro Code Does Below is a simple VBA macro I used to measure a group of cells...
I've been on a mission the past two weeks to craft a pair of macros to lighten and dark a...
What This VBA Code Does This VBA macro code will allow you to remove a specific fill color from your...
Managing Large Workbooks I've been working with a bunch of rather large Excel workbooks lately and it has come to...
What This Does Appearance can play a huge factor in the professionalism of your spreadsheet's presentation. Often there are times...
What This Does: This code will search all of the cells in your worksheet that have data entered into them...
Not So Simple When the Macro Recorder Tries to Play Tricks Today I was writing a macro that automatically highlighted...
What This VBA Code Does In this macro code I list out four different scenarios in which you can use...
What This VBA Code Does This will give you a sample of the different types of cell fills you can...
What This VBA Code Does This will give you an overview of the main ways you can change the font...