On Jul 23, 11:22 pm, Twishlist
wrote:
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?

Somewhere, but I cannot find it tonight, there's a way to change ALL
nunber in a worksheet to Absolute ( with the $ sign in front). Then
when you copy they don't change. If you want them dynnamic again you
can use the Find menu / Find / Replace and put $ in the Find window
and leave the Replace With window blank. The Find Replace won't work
when there's nothing but a blank space to change.

ed