×

Miscellaneous

[Solved] Excel Found A Problem With Formula References In This Worksheet

[Solved] Excel Found A Problem With Formula References In This Worksheet

How To Troubleshoot This Persistent Error Message Not this dialog box again! If you are reading this article, you have...

Free Example Data Sets For Spreadsheets [Instant Download]

Free Example Data Sets For Spreadsheets [Instant Download]

Spreadsheet Sample Data in Excel & CSV Formats I have put this page together to provide everyone with data that...

How To Show The Developer Ribbon Tab [With Pictures]

How To Show The Developer Ribbon Tab [With Pictures]

Steps To Add The Developer Tab In Excel For PCAdd The Developer Tab in Microsoft WordAdd The Developer Tab in...

How To Add Comments/Notes To Your VBA Code

How To Add Comments/Notes To Your VBA Code

How To Insert A VBA Comment/Note Microsoft's VBA coding language allows you to create non-executable lines of code for commenting...

My Excel Columns Or Rows Not Hidden But Missing?!

My Excel Columns Or Rows Not Hidden But Missing?!

Why Are The Columns/Rows Missing? If you landed on this article, you’ve probably been pulling your hair out trying to...

How To Use VBA Code With Oracle’s Smart View Add-in

How To Use VBA Code With Oracle’s Smart View Add-in

What Is The Oracle Smart View Add-in? The Smart View Excel Add-in is a free Oracle tool that allows you...

How To Calculate A CAGR Formula In Excel (Correctly)

How To Calculate A CAGR Formula In Excel (Correctly)

Interactive Excel CAGR Calculator Tool If you are looking for a way to quickly calculate a CAGR for a PowerPoint...

How To Get Data From A Picture In Excel

How To Get Data From A Picture In Excel

Make This Picture In Excel! Has your manager ever emailed you to put together a table or chart based on...

Excel Guru’s Top Interview Questions To Ask [What I Look For]

Excel Guru’s Top Interview Questions To Ask [What I Look For]

Why Excel Competency Is Important It’s truly amazing how much of the business world relies on Microsoft Excel. What is...

New Years Resolution Goal Tracker

New Years Resolution Goal Tracker

Why I Created This Goal Tracker At the start of every new year, my wife and I have a tradition...

VBA To Determine If Number Is Odd Or Even

VBA To Determine If Number Is Odd Or Even

What This VBA Code Does You may have found yourself in a situation where you need to determine if a...

How To Change Excel’s Group Outline Direction Settings

How To Change Excel’s Group Outline Direction Settings

Excel's row/column grouping functionality is a handy way to consolidate or provide a hierarchical order to your spreadsheet data. The...

Calculating Picture Frame Spacing in Excel (Inches)

Calculating Picture Frame Spacing in Excel (Inches)

The Chore of Hanging Pictures Often times when I find myself needing to hang multiple picture frames next to each...

All About Excel’s New LET Function

All About Excel’s New LET Function

Excel has released a new function in 2020 that will allow you to define variables within the scope of the...

7 Ways To Generate Unique Values List In Excel

7 Ways To Generate Unique Values List In Excel

There are many scenarios you may come across while working in Excel where you only desire unique values in a...

How To Enable Office Scripts For Excel Online

How To Enable Office Scripts For Excel Online

Excel for the web (aka Excel Online) now has scripting functionality akin to VBA! We are in the early stages...

How To Install Office 365 Insider Fast Version

How To Install Office 365 Insider Fast Version

What Is The Office Insider Version? The “Insider” version of Office (formerly known as “Insider Fast”) is used to test...

TSG HQ – My Home Office Setup

TSG HQ – My Home Office Setup

Today I’m going to give you behind-the-scenes access to all the equipment I use here at the TSG headquarters (aka...

Will VBA Die in 2022? Is It Worth Learning? [Inside Scoop]

Will VBA Die in 2022? Is It Worth Learning? [Inside Scoop]

VBA is a coding language used by millions of people across the world to automate tasks in Microsoft Office products....

How To Build A Modern-Looking VBA Userform

How To Build A Modern-Looking VBA Userform

The Need For A Modern UI Let’s face it, VBA Userforms haven’t had much love from Microsoft over the past...

Creating Userform Buttons That Highlight Mouse Hovering

Creating Userform Buttons That Highlight Mouse Hovering

In this article, I am going to explain the process I use to create an emphasis effect on my userforms...

The VBA Guide For Using Userform ListBox Controls

The VBA Guide For Using Userform ListBox Controls

What Are ListBox Controls? ListBoxes are a great way to manage tables within your userform. I have used them in...

My Personal Macro Workbook Disappeared! How To Get It Back

My Personal Macro Workbook Disappeared! How To Get It Back

Where Did It Go!? Man-oh-man did this freak me out the first time this happened! One day, I opened up...

VBA To Load Your Own Recent Colors To PowerPoint Palette

VBA To Load Your Own Recent Colors To PowerPoint Palette

What This VBA Code Does Do you have certain colors outside of the Microsoft theme color presets that you like...

VBA Code To Insert An Image Into A Cell Comment

VBA Code To Insert An Image Into A Cell Comment

What This VBA Code Does Using screenshots inside a cell's comment box is a neat little trick I like to...

PowerPoint VBA Remove All Animation Effects

PowerPoint VBA Remove All Animation Effects

What This VBA Code Does This VBA macro code will loop through all slides within the ActivePresentation and remove any...

Christmas Expense & Budget Tracker Excel Template (Free!)

Christmas Expense & Budget Tracker Excel Template (Free!)

It's That Time Of Year Again! If you love analyzing numbers (and chances are if you are a fan of...

Prevent Excel From Automatically Formatting Data As Dates When Pasted

Prevent Excel From Automatically Formatting Data As Dates When Pasted

What This VBA Code Does Lars-Erik reached out to me via Facebook with an interesting code concept that would prevent...

Excel Weaknesses: A Wishlist For Much Needed Improvements

Excel Weaknesses: A Wishlist For Much Needed Improvements

As Microsoft continues to persuade people to sign up for their Office 365 subscription in lieu of purchasing individual copies...

VBA Code To Convert Column Number to Letter Or Letter To Number

VBA Code To Convert Column Number to Letter Or Letter To Number

What This VBA Code Does In this article, I'm going to show you how to easily convert a cell column...

How To Customize The Order Of Your Excel Slicer Buttons

How To Customize The Order Of Your Excel Slicer Buttons

Slicers Are Great, But Have Limitations Slicers are a great way to provide interactivity to your Excel spreadsheets. They allow...

Best Online Excel & VBA Courses (2022)

Best Online Excel & VBA Courses (2022)

Choices, Choices, & MORE Choices! With so many educational options available on the internet these days, it can be overwhelming...

How To Change The Mouse Cursor Icon In Your VBA Userform

How To Change The Mouse Cursor Icon In Your VBA Userform

Why Change Your Userform's Cursor? There may be certain instances where it makes sense to change the look of the...

How To Set Focus To The Excel Window After Showing A Userform

How To Set Focus To The Excel Window After Showing A Userform

What This VBA Code Does There may be situations when you are using Excel Userforms where you would like the...

VBA Function To Determine What Is Currently Selected On Spreadsheet

VBA Function To Determine What Is Currently Selected On Spreadsheet

What This VBA Macro Does This VBA function is a handy piece of code that categorizes what is currently selected...

My First Microsoft Excel MVP Award!

My First Microsoft Excel MVP Award!

UPDATE: In July 2017, I received my second MVP award from Microsoft! Thank you for supporting this website and continuing...

Top Microsoft Excel Add-ins You Should Consider Using

Top Microsoft Excel Add-ins You Should Consider Using

What Are Add-ins? Add-ins for Excel are similar to the apps you can download and purchase for your smartphone. They...

Retain Font Formats After Changing An Excel Shape’s Formula

Retain Font Formats After Changing An Excel Shape’s Formula

This is a frustration I seem to always face while creating dashboards or graphics for Excel reports. I create a...

Combining Text With The CONCAT and TEXTJOIN Excel Functions

Combining Text With The CONCAT and TEXTJOIN Excel Functions

Hey everyone! Chris here and I want to introduce you to a new Excel blog called Spreadsheeto. Bloggers Mikkel and...

VBA Code To Change All Shape & Chart Placement Properties

VBA Code To Change All Shape & Chart Placement Properties

What This VBA Macro Does I deal with shapes and charts on a daily basis and one of my (many)...

VBA Code To Measure Selected Cell Range Height & Width In Pixels

VBA Code To Measure Selected Cell Range Height & Width In Pixels

What This VBA Macro Code Does Below is a simple VBA macro I used to measure a group of cells...

How To Create Your Own User-Defined Functions With VBA

How To Create Your Own User-Defined Functions With VBA

Hey everyone! Chris here and I want to introduce you to author/blogger Allen Wyatt. Allen has been running a weekly...

Excel PowerBall Lottery Ticket Checker Spreadsheet

Excel PowerBall Lottery Ticket Checker Spreadsheet

Checking Lottery Picks = Painful With the new trend of ginormous lottery jackpots, there seem to be more and more...

Excel PowerBall Lottery Simulator Spreadsheet

Excel PowerBall Lottery Simulator Spreadsheet

With all the excitement over the $900 Million PowerBall Jackpot this past weekend, I thought it would be interesting to...

Get Scrollbar To Appear When Launching A VBA Userform

Get Scrollbar To Appear When Launching A VBA Userform

What This VBA Code Does For some reason when you have a scrollable textbox, the scrollbar does not initially appear...

How To Get Office 2016 With A 365 ProPlus Account

How To Get Office 2016 With A 365 ProPlus Account

A Little Background I was literally pulling out my hair trying to figure out how to get my hands on...

Launch VBA Userforms In Correct Window With Dual Monitors

Launch VBA Userforms In Correct Window With Dual Monitors

What This VBA Code Does Having dual monitors is one of the best ways to increase efficiency as a data...

Format VBA Code Inside A Microsoft Word Document

Format VBA Code Inside A Microsoft Word Document

What This VBA Code Does I have found over the years that organizing your past VBA code snippets can really...

Online Excel & VBA Blog Resources

Online Excel & VBA Blog Resources

Your Excel Resource Guide I'm sure every Excel blog out there has some sort of directory page with recommendations of...

How To Run Personal VBA Macros in Microsoft PowerPoint

How To Run Personal VBA Macros in Microsoft PowerPoint

PowerPoint Is Not Excel! I have spent probably 90% of my Microsoft Office usage inside Excel.  Because of this, I...

Excel QAT Setups From Some Of The Excel Community’s Finest

Excel QAT Setups From Some Of The Excel Community’s Finest

What's a QAT? QAT is short for Quick Access Toolbar and this bar is typically setup to store frequently used Excel functionalities;...

Highlight All Cells Containing A Specific Value

Highlight All Cells Containing A Specific Value

What This Does: This code will search all of the cells in your worksheet that have data entered into them...

How To Mimic ThisPresentation In VBA For PowerPoint

How To Mimic ThisPresentation In VBA For PowerPoint

What This VBA Code Does It's unfortunate that the Microsoft developer's did not include a ThisPresentation class in PowerPoint's VBA...

Formulas To Calculate Longest & Current Win Streaks

Formulas To Calculate Longest & Current Win Streaks

All About The Wins As we start to head into the summer months here in the United States, I thought...

Loop Through All Currently Open Workbooks And Modify Them

Loop Through All Currently Open Workbooks And Modify Them

What This VBA Code Does This bit of VBA code shows you how to loop through all currently open Excel...

Activate Object Library References in Visual Basic Editor

Activate Object Library References in Visual Basic Editor

What This VBA Code Does This bit of code will allow you to turn on specific VBA reference libraries (I...

Why Does Excel Say Cell Values Are Not Equal When They Are?

Why Does Excel Say Cell Values Are Not Equal When They Are?

What's Wrong With Excel? I try to get on the Mr. Excel forums a few times a week and this...

Debugging VBA Code: Adding Breakpoints

Debugging VBA Code: Adding Breakpoints

Sometimes it pays to stay in bed on Monday, rather than spending the rest of the week debugging Monday’s code....

VBA Pattern Validation (Characters And Numbers)

VBA Pattern Validation (Characters And Numbers)

Today we are going to discuss how you can use VBA to ensure that cell values match a specific pattern. ...

VBA Code To AutoFit Columns

VBA Code To AutoFit Columns

What This VBA Code Does In this macro code I list out four different scenarios in which you can use...

Display Object Library Reference GUID Information

Display Object Library Reference GUID Information

What This VBA Code Does This VBA code will display the GUID information for all activated references in the VBA...

How To Determine Your Variable Type

How To Determine Your Variable Type

What This VBA Code Does Are you ever unsure of what kind of variable you need to declare? You can...

Wrapping an IFERROR Function Around Your Formulas

Wrapping an IFERROR Function Around Your Formulas

What This VBA Code Does This VBA macro will add an IFERROR function around any cell formula in a given...

Explaining Private vs. Public Declarations

Explaining Private vs. Public Declarations

So What’s This Private and Public Stuff Mean? The VBA terms Private and Public declare the access allowed to the...

VBA Code To Create, Modify, & Delete Userforms

VBA Code To Create, Modify, & Delete Userforms

What This VBA Code Does  I found this concept in an Excel forum and it was attributed to an Excel...

Cell Fills (Color, Patterns, & Gradients)

Cell Fills (Color, Patterns, & Gradients)

What This VBA Code Does This will give you a sample of the different types of cell fills you can...

Make Your VBA Userform Float On Screen

Make Your VBA Userform Float On Screen

What This VBA Code Does Have you ever wanted to have the ability to click off of a displayed userform...

How To Create A Personal Macro File

How To Create A Personal Macro File

What Is A Personal Macro File? A Personal Macro file is a file you can create to store VBA code...

What Does Dim Mean When Coding VBA Macros?

What Does Dim Mean When Coding VBA Macros?

What Is Dim And Why Do People Use It? Dim is short for the word Dimension and it allows you...

Center An Object (Textbox, Shape, etc…) On Your Slide

Center An Object (Textbox, Shape, etc…) On Your Slide

What This VBA Code Does Basically, anything you can select on your PowerPoint slide is considered an object. What this...

How To Prevent Copy/Paste Merged Cell Errors [Solved!]

How To Prevent Copy/Paste Merged Cell Errors [Solved!]

What Is Center Across Selection? If you are like most people (me included for quite some time), I suspect you...

PowerPoint “Set” Statements

PowerPoint “Set” Statements

What This VBA Code Does When first learning how to code VBA for PowerPoint, it was a real struggle for...

A Guru State Of Mind

A Guru State Of Mind

I Finally Did It! I’ve thought long and hard about what epic topic I would cover for my very first...