G
Guest
I have several worksheets with cells that are linked to other worksheets and
to other workbooks. Those other sheets and workbooks are now obsolete and I
need to paste the current values of those linked cells with their current
values....i.e., search the worksheet line by line, find a linked cell, copy
and paste its current LINKED value into that cell (thus overwriting the
link...), then continue searching for the next linked cell and do the same
until the linked values of the cells in entire worksheet have been replaced
with their current linked values.
Is there a function to do this? Or, is a macro the only way? If macro,
then how do I write it?
Thanks..........TomCat
to other workbooks. Those other sheets and workbooks are now obsolete and I
need to paste the current values of those linked cells with their current
values....i.e., search the worksheet line by line, find a linked cell, copy
and paste its current LINKED value into that cell (thus overwriting the
link...), then continue searching for the next linked cell and do the same
until the linked values of the cells in entire worksheet have been replaced
with their current linked values.
Is there a function to do this? Or, is a macro the only way? If macro,
then how do I write it?
Thanks..........TomCat