I have struggled long and hard in the early days coming to grips with variable types and exactly these types of errors. since those early days, I now use "Option Explicit" in EVERY module to help prevent type errors. Also, when declaring variables, I use Hunagrian Notation, e.g. Dim lngIndex as...