Hi,

We often have to copy data from one worksheet to another (usually between a
hidden unprotected sheet with a DDE link to other software, and a visible
protected one).

Before we updated to W2000/XL2000, the obvious kludge of putting
'=othersheet!C20' (etc) in each cell of the visible (destination) sheet
worked OK. There
are usually a few hundred cells involved.

Now, we get #REF! messages on random occasions, whether or not the DDE link
to the other software is activated.

Our workaround was to write some VBA to copy ranges of cells, with the
ranges and offsets defined by constants. Writing the code was surprisingly
difficult, and the result looks too messy to be worth posting.

We've searched the web and this ng for a neat solution, but may have missed
something.

Does anyone have a 'Range_Copy' macro that's both tidy and easily
understandable by
someone who wants to adapt it to a particular application?

Regards