Microsoft Excel - Macros - Options

This should go at the top of the macros.

' Option Explicit forces you to declare all your variables.
Option Explicit
 
' Makes all "text comparisons" case insensitive
Option Compare Text