Join the Newsletter Product Help
Search
×
Excel VBA About Shop
light graph cubes

Be The Expert
In Your Office

Popular Products

See all products →
Tickmark
Tickmark

This add-in was built to help all users of Microsoft Excel alleviate the painful process o...

Learn More >>
E2P
E2P

Automate the copy & paste actions needed to send Excel charts, data tables, and images int...

Learn More >>
My First Add-in
My First Add-in

The My First Add-in template allows you to easily create your very own Ribbon-based Micros...

Learn More >>
My Brand
My Brand

Integrate your company or personal brand into the Excel Ribbon. Store up to 9 custom forma...

Learn More >>

Master Excel

See all Excel guides →
How To Change Excel’s Group Outline Direction Settings
How To Change Excel’s Group Outline Direction Settings

Learn how to adjust the Outline Group settings in Excel to change the direction of how cells expand ...
How To Prevent Copy/Paste Merged Cell Errors [Solved!]
How To Prevent Copy/Paste Merged Cell Errors [Solved!]

If you are like most people (me included for quite some time), I suspect you have never heard of the...
How To Write A Checkmark Symbol Formula in Excel
How To Write A Checkmark Symbol Formula in Excel

Symbols are great to incorporate into your Excel spreadsheets as they often can add fantastic visual...
Override Values With Formula Using Power Query
Override Values With Formula Using Power Query

In this article, you will learn how to override specific values within a table column using a logica...
Prevent Auto-Hyperlinking In Excel
Prevent Auto-Hyperlinking In Excel

By default Excel will convert text to a hyperlink if it determines your data is a URL or an email ad...
How To Build Waterfall (Bridge) Charts In Excel
How To Build Waterfall (Bridge) Charts In Excel

In this Excel tutorial, you will learn how to build a Waterfall/Bridge chart in Microsoft Excel. The...

Master VBA

See all VBA guides →
Shortcut To Switch Back And Forth Between Two Excel Worksheet Tabs
Shortcut To Switch Back And Forth Between Two Excel Worksheet Tabs

Since a shortcut to flip between Excel tabs didn't seem to exist, I set out to figure out an alterna...
How to Easily Install/Uninstall Excel VBA Add-in Files
How to Easily Install/Uninstall Excel VBA Add-in Files

Learn how to take the Excel or PowerPoint add-in file you downloaded from the internet and properly ...
Setting The Proper Password Protection Using VBA Coding
Setting The Proper Password Protection Using VBA Coding

See all the various ways you can automate protecting your worksheets with VBA macro coding.Plus I cr...
VBA To Handle White Cell Fill Colors
VBA To Handle White Cell Fill Colors

This VBA macro targets either white filled or empty fill colored cells within your selection and mak...
How To Determine Your Variable Type
How To Determine Your Variable Type

Are you ever unsure of what kind of variable you need to declare? You can use...
Prevent Your VBA Code From Running While In Read-Only Mode
Prevent Your VBA Code From Running While In Read-Only Mode

I had an instance where I needed to prevent users from running a workbook's macros unless the workbo...

Fresh Off The Sheet

List of the 50 States, Abbreviations, & Capitals
List of the 50 States, Abbreviations, & Capitals

A clean list of all 50 states in the United States, the two-character abbreviations, region, and the...
Get Your Manager to Pay For Your Excel Training (Amazing Email Templates)
Get Your Manager to Pay For Your Excel Training (Amazing Email Templates)

Microsoft Excel MVP Chris Newman reveals his email templates you can steal to ask your boss to pay f...
How To Sum Dynamic Array Function Spill Ranges
How To Sum Dynamic Array Function Spill Ranges

Microsoft Excel MVP Chris Newman shows you a variety of ways to add together dynamic array formulas....
Dynamic Array Formula Spill Ranges With Charts
Dynamic Array Formula Spill Ranges With Charts

Excel MVP Chris Newman shows how to link Dynamic Array formula Spill Ranges into your Excel Charts t...
4 Formulas That Can Return An Excel Tab’s Name
4 Formulas That Can Return An Excel Tab’s Name

Microsoft Excel MVP Chris Newman teaches you how to return a tab name with just a spreadsheet formul...
VBA Function To Validate Range Address
VBA Function To Validate Range Address

Discover how to effectively validate cell references in Excel VBA. This guide provides an easy-to-un...
[Solved] Excel Found A Problem With Formula References In This Worksheet
[Solved] Excel Found A Problem With Formula References In This Worksheet

Excel MVP Chris Newman shows you how to get rid of the Excel error message pertaining to "Excel foun...
3 Ways To Alternate Row Colors in Excel [Guide]
3 Ways To Alternate Row Colors in Excel [Guide]

Excel MVP Chris Newman teaches you how to apply dynamic formatting to alternate row colors (this is ...
VBA Code To Find Last Row Or Last Column (Best Way)
VBA Code To Find Last Row Or Last Column (Best Way)

Discover the best methods to make your VBA code dynamic by coding in a way that allows your macros t...
Microsoft Office 2023 Theme Color Update
Microsoft Office 2023 Theme Color Update

Explore Microsoft Office's 2023 color theme update, designed with a focus on accessibility and user ...
Wingdings & Webdings Font Icon Character Map (Printable Cheat Sheet)
Wingdings & Webdings Font Icon Character Map (Printable Cheat Sheet)

Excel MVP Chris Newman releases his Webdings & Wingdings font cheat sheet translator to easily find ...
VBA Code To Highlight All Instances of Word/Phrase Within A Range
VBA Code To Highlight All Instances of Word/Phrase Within A Range

Use VBA macro doe to search through all text in a given range and format that text any way you’d l...

[FREE DOWNLOAD] Top 50 Most Useful Excel Features eBook (From Excelevate)

Email It To Me >>
X