G
Guest
Have tried to copy range of cells containing formulas, to another worksheet,
but can only manage to save values only by 'paste special'. The formulas
lose their links and display REF!
What I want to do is copy the whole range, retaining the links in the
process. This would be the equivalent of entering a formula in each
dependent cell and linking to the corresponding cell in the source worksheet.
Is it possible to do this across multiple cells (a range) in one go?
but can only manage to save values only by 'paste special'. The formulas
lose their links and display REF!
What I want to do is copy the whole range, retaining the links in the
process. This would be the equivalent of entering a formula in each
dependent cell and linking to the corresponding cell in the source worksheet.
Is it possible to do this across multiple cells (a range) in one go?