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