Use the worksheet codename and remove link to c7 if it never changes. If
also makes the copy operation simpler by referring to the sheet by its
codename.

e.g

Sheets("MyTarget").Range("A1") = MyCodeName.Range("A1")

--

Regards,
Nigel




"douglass" wrote in message
...
I have two open worksheets. The VBA would copy data from the source
worksheet then paste that information to the target worksheet.

The exact target worksheet name is always in cell
c7 of the source worksheet. So, based on that value, it first locates the
same sheet number in the target Worksheet, then pastes the data.

The source worksheet (tab) name keeps changing and does not always match
precisely the name in cell c7 of that sheet (which does not change)
--
douglass