How to past formulas without updating external links
 

In VBA, I am copying a worksheet over to another worksheet by 1 column. So
assume my copy range is A1:D5 and my paste range is B1:E5. When I paste, the
non absoluted formulas of course update. Now the problem that is occuring is
that some of the cells have links to external files. When the copy occurs,
excel looks to update the link to the external file. However the external
file may no longer exist. A dialogue box comes up saying "File not Found".

Is there a way for me to do this, without triggering the dilaogue box. I do
not care if the values are correct in the paste range. But I do want to see
that formulas have shifted for all ranges that were not absoluted.

Thanks