If your row number is greater than 9, then this line of code will alyways give you a row number of 1 , so you're not really checking your whole range

E.g Cell C$14; tmpR = C14; sRange_Row = 1


VB Code:
  1. sRange_Row = tmpR(2)