Why Request Excel Funding For Yourself? It has always amazed me how little formal education employees have on the software...
You Need To Check Your Cell Address Input A common task when using VBA with Excel is to validate cell...
Dynamic VBA Code With Last Row/Column Finding the Last Row or Last Column within your VBA code is key to...
What This VBA Code Does Have you ever had to search through a large Excel spreadsheet to find specific text?...
What This VBA Code Does Manually copying and pasting website titles can be tedious, error-prone, and time-consuming. However, by writing...
What This VBA Code Does Sometimes you might be writing macro code that requires reaching out to cloud-based files or...
Parts Of A Ribbon Button’s Tool Tip Programatically, there are two parts to a button’s tool tip box that appears...
VBA Coding With Shape Objects In this comprehensive guide, you will be learning all the ways you can create and...
Deleting Rows With For Each Loop Misses Rows When I first attempted to delete rows using VBA code I thought...
There may be times when you would like to de-clutter your data labels so that smaller or zero values are...
I’ve had quite a few IT administrators request that I provide an MSI Installer file (often referred to as a...
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 The following VBA code will show you how to utilize the power of Excel’s XLOOKUP...
How To Insert A VBA Comment/Note Microsoft's VBA coding language allows you to create non-executable lines of code for commenting...
Splitting Up Your Excel Sheets If you’ve come across this article, chances are you are looking for a solution that...
What This VBA Code Does There may be times when you need to incorporate coloring your worksheet tabs in your...
What Is The Oracle Smart View Add-in? The Smart View Excel Add-in is a free Oracle tool that allows you...
What This VBA Code Does You may find yourself needing to override a current Excel file with changes using VBA...
What This VBA Code Does The following VBA examples will show you how to insert a row or column based...
No Coding Experience? No Problem! First I want to congratulate you because if you are taking the time to read...
What This VBA Code Does If you live dangerously and have multiple Pivot Tables sporadically on a single sheet (I’ve...
What This VBA Code Does There may be times when you need to carry out a VBA automation on all...
What This VBA Code Does There may be instances where you need to ensure there are no duplicate values within...
What This VBA Code Does You may have found yourself in a situation where you need to determine if a...
There are a ton of great data programs out there that integrate very nicely with Excel. The problem I see...
What This VBA Code Does This VBA code will show you how to allow your user to select a folder...
What This VBA Code Does If you are trying to hide all shapes in a worksheet, yet some of those...
What This VBA Code Does The below code will show you how to utilize an Excel Table Object to populate...
What This VBA Code Does There may be times when you need to refresh the user interface (UI) of your...
Dealing With SuperScripts/Subscripts Sometimes you receive data or copy data that has superscripts or subscripts that you really don’t want...
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 I hate changing the Freeze Pane location because it takes two steps instead of one....
What This VBA Code Does There are a plethora of new Dynamic Array functions being released in Excel that produce...
With the release of integrated stock pricing in Microsoft Excel, it was unfortunate there wasn’t any sort of setting that...
Not As Easy As You’d Think… One would think that saving something as a picture file (png, jpg, etc…) inside...
What This VBA Code Does You may run into instances where you need to alphabetically sort your cell data (typically...
Stop The Madness! One thing that has always annoyed me with Excel Tables, is how slow it can be to...
You Finally Found It! Yes, I’ve been there! You’ve spent days scouring the internet to find a solution to a...
What This VBA Code Does In my day job, I often have to add a prefix to thousands of ID...
What This VBA Code Does I had a colleague at work come to me with some code he had found...
What This VBA Code Does Often times when I am preparing spreadsheet reports, I find myself needing to perform minor...
What This VBA Code Does You are most likely reading this article because you thought turning off ScreenUpdating and DisplayAlerts...
I’m currently working on a consulting project where a VBA macro within an Excel file needs to run every morning...
The Need For A Modern UI Let’s face it, VBA Userforms haven’t had much love from Microsoft over the past...
I’ve run into a few times where I felt the user experience would be more streamlined if I gave them...
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 Ever get those annoying dotted lines on all your spreadsheets after viewing a print preview?...
What This VBA Code Does If you do any data loading to databases and prepare/clean that data in Excel, you...
What This VBA Code Does I have run into a couple of instances recently where I needed to clean up...
What Are ListBox Controls? ListBoxes are a great way to manage tables within your userform. I have used them in...
Where Did It Go!? Man-oh-man did this freak me out the first time this happened! One day, I opened up...
You may come across times where you write a beautiful Excel macro with lots of nifty VBA code and when...
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 I’ve had numerous instances over the years when I have needed to target blank or...
I’ve run into this issue numerous times and I just figured out how to prevent the dreaded error message from...
What This VBA Code Does Today, a colleague of mine described to me a situation (aka annoyance) he was trying...
What This VBA Code Does The following VBA macro code will show you a couple of different ways to insert...
What This VBA Code Does The following VBA macro code will allow you to create navigation arrow buttons that will...
What This VBA Code Does The following VBA macro code provides a function that tests if a worksheet exists in...
What This VBA Code Does This VBA function will accept a file path text string and confirm if the file...
What This VBA Code Does If you are using Headers or Footers for your spreadsheets, the chances are you're going...
Why Is This Important? When you are writing VBA macros that rely on a user’s selection, you want to make...
There may be occasions when you will want to export/save a particular PowerPoint slide(s) as an image file. A real...
What This VBA Code Does If you have ever formatted VBA userforms, you’ve most likely noticed that the color codes...
A couple months ago I received an email from Titus who was looking for a way to easily populate and...
What This VBA Code Does Do you have certain colors outside of the Microsoft theme color presets that you like...
What This VBA Code Does I recently needed to create a VBA function that tests if a particular shape object...
What This VBA Code Does The following VBA code will provide you with a way to delete all shapes from...
Lately, I have been writing a lot of VBA code dealing with the creation of shapes and managing them. I...
What This VBA Code Does Looping is a great coding technique to condense the amount of VBA lines you write....
What This VBA Code Does If you are a formatting nut like me, you will most likely appreciate an issue...
What This VBA Code Does Using screenshots inside a cell's comment box is a neat little trick I like to...
What This VBA Code Does The following VBA macro code is something I use all the time to manipulate the...
What This VBA Code Does This VBA macro code will loop through all slides within the ActivePresentation and remove any...
What This VBA Code Does The following code will show you how to take the currently selected shape in an...
What This VBA Code Does When creating dashboards you will want to try your best to keep your spacing even...
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...
What This VBA Code Does In PowerPoint, it can be very useful to know if the object you are working...
What This VBA Code Does This VBA code is a nifty little I created to solve the hassle of selecting...
What This VBA Code Does This VBA macro function will allow you to generate a string of characters at random...
What This VBA Code Does In this article, I'm going to show you how to easily convert a cell column...
What This VBA Macro Code Does When you ask your users to supply a file name during your VBA automation,...
Referencing Worksheets in Excel When you are working with VBA inside Excel, it is more than likely that you will...
What This VBA Code Does Unfortunately when password protecting your worksheets, there is no option to check that will enable...
What This VBA Code Does I had a project today that required me to change the scope of all my...
What This VBA Code Does Excel does this annoying thing where it prevents you from creating custom Table or Slicer...
Why Change Your Userform's Cursor? There may be certain instances where it makes sense to change the look of the...
What This VBA Code Does There may be situations when you are using Excel Userforms where you would like the...
Why Manually Adjust Your Y-Axis? By default, Excel will automatically decide the minimum and maximum values of your vertical (Y)...
QUESTION How can a find the last cell on a spreadsheet based on a given color? SOLUTION This VBA macro...
What Are Arrays? Arrays are a variant type variable that you can use in VBA coding to store a list...
Why Is This Happening? This year (July 2016) Microsoft decided to heighten its security features and block files that are...
What This VBA Code Does The following VBA macro will show you how to loop through only chart objects that...
What This VBA Code Does I often have a routine of copying files from one month to another. The only...
What This VBA Macro Code Does The business world has increasingly become more reliant on mobile computing with devices such as...
What This VBA Code Does The business world has increasingly become more reliant on mobile computing with devices such as...
What This VBA Macro Does This VBA function is a handy piece of code that categorizes what is currently selected...
What This VBA Code Does I often find myself needing to set up monthly folders for routine reports. Instead of...
What This VBA Code Does It happened again today...I received 10 Excel line charts that needed to be "properly" formatted...
What This VBA Code Does There may be times when you want to incorporate code from your add-ins into other...
What This VBA Code Does Here is a simple VBA macro that will remove any fill colors from your selected...
What This VBA Code Does I just got done updating a VBA userform requiring a textbox that would only accept...
What This VBA Macro Code Does I've written a few macros over the past few days that have required the...
The following VBA code was inspired by a YouTube video I came across where Excel MVP Oz Du Soleil and...
What This VBA Macro Code Does When you are trying to understand an unfamiliar workbook or Excel model, it can...
What This VBA Macro Does I deal with shapes and charts on a daily basis and one of my (many)...
What This VBA Macro Code Does Below is a simple VBA macro I used to measure a group of cells...
What This VBA Code Does Back in my early days of teaching myself how to write VBA, I found myself...
Sometimes when you have models that are dealing with sensitive information, you want to take extra steps to prevent that...
Hey everyone! Chris here and I want to introduce you to author/blogger Allen Wyatt. Allen has been running a weekly...
Transferring VBA Through Worksheet Objects The easiest way to copy over VBA code while copying your worksheets into a new...
What This VBA Code Does This post is a follow-up article to Find And Replace With Excel VBA. The following...
What This VBA Code Does This macro code will ensure a specific worksheet tab is viewed every time the Excel...
What This VBA Code Does When you check the "Insert Rows" option in the Protect Sheets dialog box, it only...
What This VBA Macro Code Does The following two examples of VBA code show you how you can automate copy...
What This VBA Code Does Have you ever seen a formula in Sheet1 where it is written with references to...
What This VBA Code Does For some reason when you have a scrollable textbox, the scrollbar does not initially appear...
I've been on a mission the past two weeks to craft a pair of macros to lighten and dark a...
What Is A Named Range? Creating a named range allows you to refer to a cell or group of cells...
Is There An ALT-TAB Excel Equivalent? One of my all-time favorite keyboard shortcuts is ALT + TAB. This simple keyboard...
What This VBA Code Does This VBA code will run through all the tabs in your workbook and remove any...
What This VBA Code Does Having dual monitors is one of the best ways to increase efficiency as a data...
What This VBA Code Does There are two types of Sheets within an Excel Workbook. Worksheets Chart Sheets The below...
Today we are going to discuss how you can automatically make your VBA code execute based on a specific cell...
What This VBA Code Does This VBA macro code will allow you to remove a specific fill color from your...
What This VBA Code Does This is a great little snippet of code I often use whenever I am cleaning up...
What This VBA Code Does This VBA macro code will go through your Active Word document and remove any duplicate...
What This VBA Code Does This VBA macro code with go through the Active Word Document and remove any instances...
What This VBA Code Does These VBA macro snippets will show you how to target and loop through specific controls...
What This VBA Code Does This VBA code looks for any shape within the ActiveWorkbook with a specific name and...
What This VBA Code Does I have found over the years that organizing your past VBA code snippets can really...
Automating Text Files With VBA Useful? Text files can be a very fast and simple way to read and store...
What This VBA Code Does This VBA code will use the power of Regular Expressions to parse through text and...
What This VBA Code Does You never know what your users are going to type and that's why it is...
One of the most prosperous skills I have picked up over the years as a financial analyst has been the...
Quickly Emailing Your Spreadsheets I absolutely love using the Email As Attachment functionality provided by Excel. It's great for quickly...
Dynamic Code Is Vital! A huge turning point for me when I was teaching myself how to write VBA was...
What This VBA Code Does This VBA macro will take a list of sheet names within an Excel table and...
What This VBA Macro Code Does I found this code snippet on an Ozgrid forum post written by a fellow...
Installing Your Excel Add-in1. Ensure Your Excel Add-in File Is Unblocked2. Save Your Excel Add-in File To Your Computer3. Enable...
Quality Matters I've written many times in the past on how the quality and formatting of your work can separate...
What This VBA Code Does In Excel and Microsoft Word you cannot undo a macro once it has run. Sometimes...
**Hey, it's Chris here! The following is a guest post by a fellow VBA blogger named Ryan Wells who has...
Your Complete Looping Guide Looping is extremely important when coding because it can shorten up the length of your code...
Managing Large Workbooks I've been working with a bunch of rather large Excel workbooks lately and it has come to...
What This VBA Code Does This VBA code will show how to keep cycling through an input box prompt until...
What This VBA Code Does Whether you are wanting to know how many times a double 'S' appears in the...
What This VBA Code Does Sometimes it is vital to get your lists in order. Below are a couple of...
Removing Blanks From Your Data A question I see asked a great deal on Excel forums is how to delete...
Charts, Charts, & More Charts! Graphical visualizations are arguably the pinnacle of how an analyst shares his/her results and possessing...
This topic has been written about in detail many times, but those who are new to VBA or even computer...
What This VBA Code Does Sometimes when you are cleaning up all the cobwebs of your data, you discover your...
What This VBA Code Does Shadows have 5 characteristics that do not easily translate from the slide view into VBA...
What This VBA Code Does This code will set a variable named ActiveShape to equal the shape that is currently...
It's pretty straight forward to filter down on specific values in your data with VBA code. You just list out...
What This VBA Does I could not find any way to call the Excel-based alignment actions with VBA, so I...
What This VBA Code Does This past weekend I was tasked with recreating a PDF document in Microsoft Word. Unfortunately,...
What This VBA Code Does There are various scenarios where you may want to calculate the time it takes for...
What This VBA Code Does This brief macro code with go through each cell in a designated range and determines...
Update! Better Solution from ExcelHero Excel MVP Daniel Ferry from ExcelHero graciously provided a much more eloquent solution than my...
What This Does If you want to prevent errors from occurring when you macro code is running, it may be...
What This Does If you have an Excel workbook or worksheet that houses a large number of tables and you...
It's That Time Of Year Again! For most of us, the months of November and December are spent preparing our...
What This Does When you create a chart in Microsoft Excel, the chart's default setting is to not graph any...
PowerPoint Is Not Excel! I have spent probably 90% of my Microsoft Office usage inside Excel. Because of this, I...
What's a QAT? QAT is short for Quick Access Toolbar and this bar is typically setup to store frequently used Excel functionalities;...
Where Did My Code Go? That was the question I was asking myself when I first began to create PowerPoint...
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...
What This Does There are times when you would like to know information about the currently selected shape on your...
What This Does I had an instance where I needed to prevent users from running a workbook's macros unless the...
What This Does This VBA code will allow you to instantly update all your Pivot Tables inside a workbook and...
What This Does This little macro code will go through all the external links in your workbook and break the...
What This Does Ever have an instance where you have a TON of shapes or images on your spreadsheet and...
Moving Excel Tables Into Various Word Pages This post is an add-on to a previous post I wrote covering how...
What This VBA Code Does It's that time of year again where I have been tasked to go through and...
All About The Pivot Tables! Pivot Tables and VBA can be a little tricky initially. Hopefully this guide will serve...
Prevent Destruction Many times I use worksheet protection to prevent my users from accidentally breaking formulas or disrupting formatting. With...
What VBA Code Does This PowerPoint VBA macro code will break any external link from your PowerPoint presentation. Typically these occur...
What This VBA Code Does This code will loop through each of your Form Control checkboxes and let you 'do...
What This VBA Code Does This PowerPoint VBA macro code will cycle through all the externally linked charts in your...
What This VBA Code Does Often times we want to make changes that affect every slide in the PowerPoint presentation....
Not So Simple When the Macro Recorder Tries to Play Tricks Today I was writing a macro that automatically highlighted...
Recently I found myself in a situation where another company wanted to see the formatting of numerous reports and presentations...
What This VBA Code Does It's unfortunate that the Microsoft developer's did not include a ThisPresentation class in PowerPoint's VBA...
What This VBA Code Does I have always hated the time it takes to convert text to numbers, especially on...
Version Control Keeping track of different versions of a file has always been a pain for me. I am grateful...
What This VBA Code Does Keeping all your charts perfectly formatted can be extremely tedious work! It's much easier to...
What This VBA Code Does It's probably just my OCD acting up but I HATE the look of formulas beginning...
PowerPoint Filtering This was a great idea that came from a reader named Chris Morgan. He wanted to know if...
What This VBA Code Does The below VBA macro code will allow you to select only the cells in a...
What This VBA Code Does Stop creating the same Pivot Table every month for your monthly data extracts! Create a...
Stop Manually Copying and Pasting! This post is a continuation of the current most popular blog post on The Spreadsheet Guru...
What This VBA Code Does This bit of VBA code shows you how to loop through all currently open Excel...
All About The Tables For a data analyst, Excel Tables are a necessity! They are the most efficient way to...
What This VBA Code Does Many times it is much easier to tweak VBA code through a spreadsheet versus changing the...
What This VBA Code Does This VBA code allows you to automate adding specific text (single or multiple lines) to...
What This VBA Code Does This VBA macro code will cycle through each worksheet in every currently open Excel workbook...
What This VBA Code Does This is a nifty macro. It will go through your Microsoft Word document and automatically...
What This VBA Code Does Many times we as data analyzers receive data that is not so pretty (aka unorganized)....
Taking A Previous Post One Step Further This will build from a post I previously wrote entitled Copy & Paste An...
What This VBA Code Does The VBA code below shows how you can automate inserting and image (ie company logo)...
What This VBA Code Does Learn how to insert single or multiple rows with VBA macro code in your Excel...
Moving An Excel Table Into A New Word Document In this post you will learn how to write VBA code...
What This VBA Code Does This VBA function tests to see if a specific column heading name already exists inside...
What This VBA Code Does This bit of code will allow you to turn on specific VBA reference libraries (I...
You're VBA Combo Box Cheat Sheet In this post I am going to share everything I know about using VBA...
What This VBA Code Does This VBA macro shows you how to insert a single column or multiple columns into...
What This VBA Code Does If you want to create multiple lines of text you can either use vbNewLine or...
What This VBA Code Does When handling sensitive data it is vital to display some sort of statement to let...
What This VBA Code Does This VBA macro will let you select a folder path and loop through each of...
What This VBA Code Does This VBA macro with let you specify a value and create an Excel range selection...
What This VBA Code Does These VBA macros will show you various ways to find and replace all for any...
What This VBA Code Does Don't waste your time manually unhiding tabs one by one. Use this VBA macro to...
Sometimes it pays to stay in bed on Monday, rather than spending the rest of the week debugging Monday’s code....
What This VBA Code Does This macro will allow you to customize a specific order that you want your worksheets...
Today we are going to discuss how you can use VBA to ensure that cell values match a specific pattern. ...
What This VBA Code Does Sometimes I have a huge PowerPoint deck filled with data slides from all sorts of...
Triggering A Macro Via An Event There are many events that Excel keeps track of while you carry out tasks...
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 reference a specific textbox on a worksheet and add multiple lines of text to...
Why Do This? I've received a large number of questions on how to command other programs with VBA through Excel....
What This VBA Code Does This VBA code will display the GUID information for all activated references in the VBA...
What This VBA Code Does Are you ever unsure of what kind of variable you need to declare? You can...
What This VBA Code Does This bit of VBA code looks at a text string within a specified cell and...
What This VBA Code Does This VBA macro will add an IFERROR function around any cell formula in a given...
What This VBA Code Does Ever paste in a picture or chart to your PowerPoint presentation and it's huge...like so...
So What’s This Private and Public Stuff Mean? The VBA terms Private and Public declare the access allowed to the...
What This VBA Code Does I found this concept in an Excel forum and it was attributed to an Excel...
What This VBA Code Does This macro will show you how to manipulate a file path in order to extract...
What This VBA Code Does I typically use this kind of functionality if I am trying to compile a list...
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 code allows you to lock and unlock the Aspect Ratio of a shape or...
What's The Story? One day I was teaching a co-worker how to create simple macros to use across any of...
What This VBA Code Does: This code shows a few different ways you can remove those visually irritating little squiggles...
What This VBA Code Does Want to get an input from your user? Call an Input Dialog Box to get...
What This VBA Code Does Have you ever wanted to have the ability to click off of a displayed userform...
What This VBA Code Does This VBA macro has a ton of great stuff! First it creates a shape and...
What This VBA Code Does This snippet of code will give you a couple of scenarios where you can protect...
What Is A Personal Macro File? A Personal Macro file is a file you can create to store VBA code...
What This VBA Code Does Use can use this loop to figure out which one of your Option Buttons is...
What This VBA Code Does: The VBA code below displays a message box with a selected PowerPoint item's Left, Top,...
What This VBA Code Does Get a great looking image of an Excel Chart or Table by pasting your copied...
What Is Dim And Why Do People Use It? Dim is short for the word Dimension and it allows you...
What This VBA Code Does Need to do a task on every sheet or worksheet in your workbook? Use one...
What This VBA Code Does This VBA code will loop through the columns/rows on your active worksheet and delete the...
What This VBA Code Does Basically, anything you can select on your PowerPoint slide is considered an object. What this...
What This VBA Code Does This VBA code will apply a custom border to all the pictures in your Word...
What This VBA Code Does Ever need to just delete content in your spreadsheet but you wanted to keep all...
Writing VBA Code Can’t Be This Annoying, Can It? When I first started coding in the Visual Basic Editor (VBE)...
What This VBA Code Does When first learning how to code VBA for PowerPoint, it was a real struggle for...
What This VBA Code Does This will give you an overview of the main ways you can change the font...
[FREE Training] 10 Amazing Excel Efficiency Tricks. Why Don't People Know These?!
![Learn VBA Macro Coding Basics In Excel [2023 Guide]](https://www.thespreadsheetguru.com/wp-content/uploads/2022/10/IntrotoVBAMacros.png)
![The VBA Guide To Excel Pivot Tables [Tons Of Examples]](https://www.thespreadsheetguru.com/wp-content/uploads/2022/12/VBA-Pivot-Table-Guide.png)
