Try this line
If rng.InRange(rev.Range) Then
If you were here or I were there, I'd come over and let you smack me!! It
works great!

Thank you for saving me much time and hair!
Ed