====== 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