You rock! Thank you. Works perfectly, had to delete the Range("B10") in the DO loop. Is there a way to address the cancel button operability?