How To Troubleshoot This Persistent Error Message Not this dialog box again! If you are reading this article, you have...
Spreadsheet Sample Data in Excel & CSV Formats I have put this page together to provide everyone with data that...
Steps To Add The Developer Tab In Excel For PCAdd The Developer Tab in Microsoft WordAdd The Developer Tab in...
How To Insert A VBA Comment/Note Microsoft's VBA coding language allows you to create non-executable lines of code for commenting...
Why Are The Columns/Rows Missing? If you landed on this article, you’ve probably been pulling your hair out trying to...
What Is The Oracle Smart View Add-in? The Smart View Excel Add-in is a free Oracle tool that allows you...
Interactive Excel CAGR Calculator Tool If you are looking for a way to quickly calculate a CAGR for a PowerPoint...
Make This Picture In Excel! Has your manager ever emailed you to put together a table or chart based on...
Why Excel Competency Is Important It’s truly amazing how much of the business world relies on Microsoft Excel. What is...
Why I Created This Goal Tracker At the start of every new year, my wife and I have a tradition...
What This VBA Code Does You may have found yourself in a situation where you need to determine if a...
Excel's row/column grouping functionality is a handy way to consolidate or provide a hierarchical order to your spreadsheet data. The...
The Chore of Hanging Pictures Often times when I find myself needing to hang multiple picture frames next to each...
Excel has released a new function in 2020 that will allow you to define variables within the scope of the...
There are many scenarios you may come across while working in Excel where you only desire unique values in a...
Excel for the web (aka Excel Online) now has scripting functionality akin to VBA! We are in the early stages...
What Is The Office Insider Version? The “Insider” version of Office (formerly known as “Insider Fast”) is used to test...
Today I’m going to give you behind-the-scenes access to all the equipment I use here at the TSG headquarters (aka...
VBA is a coding language used by millions of people across the world to automate tasks in Microsoft Office products....
The Need For A Modern UI Let’s face it, VBA Userforms haven’t had much love from Microsoft over the past...
In this article, I am going to explain the process I use to create an emphasis effect on my userforms...
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...
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 Using screenshots inside a cell's comment box is a neat little trick I like to...
What This VBA Code Does This VBA macro code will loop through all slides within the ActivePresentation and remove any...
It's That Time Of Year Again! If you love analyzing numbers (and chances are if you are a fan of...
What This VBA Code Does Lars-Erik reached out to me via Facebook with an interesting code concept that would prevent...
As Microsoft continues to persuade people to sign up for their Office 365 subscription in lieu of purchasing individual copies...
What This VBA Code Does In this article, I'm going to show you how to easily convert a cell column...
Slicers Are Great, But Have Limitations Slicers are a great way to provide interactivity to your Excel spreadsheets. They allow...
Choices, Choices, & MORE Choices! With so many educational options available on the internet these days, it can be overwhelming...
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...
What This VBA Macro Does This VBA function is a handy piece of code that categorizes what is currently selected...
UPDATE: In July 2017, I received my second MVP award from Microsoft! Thank you for supporting this website and continuing...
What Are Add-ins? Add-ins for Excel are similar to the apps you can download and purchase for your smartphone. They...
This is a frustration I seem to always face while creating dashboards or graphics for Excel reports. I create a...
Hey everyone! Chris here and I want to introduce you to a new Excel blog called Spreadsheeto. Bloggers Mikkel and...
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...
Hey everyone! Chris here and I want to introduce you to author/blogger Allen Wyatt. Allen has been running a weekly...
Checking Lottery Picks = Painful With the new trend of ginormous lottery jackpots, there seem to be more and more...
With all the excitement over the $900 Million PowerBall Jackpot this past weekend, I thought it would be interesting to...
What This VBA Code Does For some reason when you have a scrollable textbox, the scrollbar does not initially appear...
A Little Background I was literally pulling out my hair trying to figure out how to get my hands on...
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 I have found over the years that organizing your past VBA code snippets can really...
Your Excel Resource Guide I'm sure every Excel blog out there has some sort of directory page with recommendations of...
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;...
What This Does: This code will search all of the cells in your worksheet that have data entered into them...
What This VBA Code Does It's unfortunate that the Microsoft developer's did not include a ThisPresentation class in PowerPoint's VBA...
All About The Wins As we start to head into the summer months here in the United States, I thought...
What This VBA Code Does This bit of VBA code shows you how to loop through all currently open Excel...
What This VBA Code Does This bit of code will allow you to turn on specific VBA reference libraries (I...
What's Wrong With Excel? I try to get on the Mr. Excel forums a few times a week and this...
Sometimes it pays to stay in bed on Monday, rather than spending the rest of the week debugging Monday’s code....
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 In this macro code I list out four different scenarios in which you can use...
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 VBA macro will add an IFERROR function around any cell formula in a given...
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 will give you a sample of the different types of cell fills you can...
What This VBA Code Does Have you ever wanted to have the ability to click off of a displayed userform...
What Is A Personal Macro File? A Personal Macro file is a file you can create to store VBA code...
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 Basically, anything you can select on your PowerPoint slide is considered an object. What this...
What Is Center Across Selection? If you are like most people (me included for quite some time), I suspect you...
What This VBA Code Does When first learning how to code VBA for PowerPoint, it was a real struggle for...
I Finally Did It! I’ve thought long and hard about what epic topic I would cover for my very first...
[FREE Training] 10 Amazing Excel Efficiency Tricks. Why Don't People Know These?!
![[Solved] Excel Found A Problem With Formula References In This Worksheet](https://www.thespreadsheetguru.com/wp-content/uploads/2023/08/Excel-Found-Problem-With-Formula-References.svg)
![Free Example Data Sets For Spreadsheets [Instant Download]](https://www.thespreadsheetguru.com/wp-content/uploads/2022/10/SpreadsheetSampleData.png)
![How To Show The Developer Ribbon Tab [With Pictures]](https://www.thespreadsheetguru.com/wp-content/uploads/2022/10/UnlockOfficeDeveloperTab.png)
![Excel Guru’s Top Interview Questions To Ask [What I Look For]](https://www.thespreadsheetguru.com/wp-content/uploads/2022/12/Best-Excel-Skills-Interview-Questions.png)
![Will VBA Die in 2022? Is It Worth Learning? [Inside Scoop]](https://www.thespreadsheetguru.com/wp-content/uploads/2022/12/Is-VBA-Dead-the-current-state-of-the-Visual-Basic-Language.png)
![How To Prevent Copy/Paste Merged Cell Errors [Solved!]](https://www.thespreadsheetguru.com/wp-content/uploads/2022/12/PreventCopyMergedCellErrors.png)
