Copy & Pasting in VBA + break links (See thread: Find part of string and delete)

[thedivvy]

Hi, I am copying data & graph set ups from one Excel workbook to another, the original data being copied is in a workbook generated by a template. The template copy is never saved so consequently I don't want the copied data to think it should link to it for updating.

I have been using

Please Login or Register  to view this content.

but this causes the formulas to be overwritten with static data.

Is there another way of doing this please?

Thanks