948 Steps to 6 Figures by Learning Excel-VBA and Other Skills

Step 557 - Misspelling error

Misspelling something in VBA will probably be one of the most common errors you will run into.

You can get rid of a lot of these issues by using Option Explicit which will force automatically find many spelling errors you make.

Many spelling errors will be found at Compile time by using Debug > Compile Project

Many times a spelling error will cause a Syntax error.

An example of a spelling error is you create a range name called "a_range_name" and when you try to retrieve it via Range("a_range_nane") you spell it wrong.