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 →
[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...
How To Turn Off Excel’s AutoSave By Default
How To Turn Off Excel’s AutoSave By Default

There are a lot of cases where you may want to be selective or more in control of when you actually ...
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...
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...
Excel PowerBall Lottery Ticket Checker Spreadsheet
Excel PowerBall Lottery Ticket Checker Spreadsheet

With this Excel-powered spreadsheet you can type in all your lottery ticket picks and automatically ...
Masking (Hiding) A Password As It Is Entered In An Excel Text Box
Masking (Hiding) A Password As It Is Entered In An Excel Text Box

Today, I came across a spreadsheet that allowed a user to connect to a remote database via VBA. The ...

Master VBA

See all VBA guides →
Classified Data: Find All Numbers And Replace Them With X’s In Text
Classified Data: Find All Numbers And Replace Them With X’s In Text

Learn how you can use VBA macro coding to automatically replace any numerical values in your PowerPo...
Caution Writing PasteSpecial Macros
Caution Writing PasteSpecial Macros

One day I was teaching a co-worker how to create simple macros to use across any of his workbooks. I...
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...
Allow Groups to Expand/Collapse While Spreadsheet Is Password Protected
Allow Groups to Expand/Collapse While Spreadsheet Is Password Protected

Learn how to allow users to expand/collapse outline groupings while there is password protection on ...
VBA To Adjust Freeze Panes In Excel
VBA To Adjust Freeze Panes In Excel

I hate changing the Freeze Pane location because it takes two steps instead of one. You first have t...
VBA Code To Activate A Specific Worksheet When An Excel Workbook Opens
VBA Code To Activate A Specific Worksheet When An Excel Workbook Opens

This macro code will ensure a specific worksheet tab is viewed every time the Excel workbook file is...

Fresh Off The Sheet

Build A Tile Grid Map of The United States In Excel
Build A Tile Grid Map of The United States In Excel

Microsoft Excel MVP Chris Newman explains how you can build an amazing grid map of the United States...
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 ...

[FREE Training] 10 Amazing Excel Efficiency Tricks. Why Don't People Know These?!

View Video >>
X