Hi Rick,

Thanks, but I went back to the old version with the problem and tried
your fixes, and they did not work.

First I tried:

..ClearContents


Then I tried:

..Hyperlinks(1).Delete
..ClearContents


Then I tried:

..Hyperlinks(1).Delete
..Clear


Then I tried:

..Clear


None of them fixed the problem.

However, on my fixed version (the one that works around the problem by
closing and reopening the target workbook right before the problem
lines), I've changed the problem lines to use ClearContents, since
that is good hygiene.


Thanks,

Greg








On Feb 21, 11:44*am, "Rick Rothstein"
wrote:
First, I isolated the problem to three lines that
cleared the contents (.Value = "") of three cells.

Rather than assigning the empty string to the Value property, a better way
to clear the contents of a cell would be to use the ClearContents property
instead...

* *.ClearContents

Whether that will solve your problem or not, I don't know (hyperlinks are
more of an object than they are a value). If you don't mind deleting
formatting and all, you could just use the Clear property...

* * .Clear

and that should solve your problem. If you want to stick with your assigning
the empty string to the Value property, you might first try deleting the
hyperlink to see if that solves your problem...

* * .Hyperlinks(1).Delete
* * .Value = ""

Although I would still suggest using the Clear property in place of the
empty string assignment.

Rick Rothstein (MVP - Excel)