It will fail because we are only guessing what it is you want to do and you haven't provided sample documents. You need to be explicit about which line it fails on (ie which line is highlighted in yellow when you choose to debug)

What is the value of each of the variables when it fails? Does the current workbook have a sheet with the right name? Is the cell address valid? Did you use an exclamation to separate the cell address from the sheet name? Did you store a valid address in the Tag property of EVERY text CC? Is this even what you want to do?

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia