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

I don't get an option to debug and nothing is highlighted in yellow??

I'm only interested in a few of the content controls data maybe 5 out of the form's possible 30 or so (I've only given those ones a valid address in the tag property).

If I give every CC a valid address in the tag property it works great, but I am only interested in a few of the CC's