Foxguy --

It indicates the crash at:
Case Range("Name1").Value

Thanks!