C
Christopher R. Lee
Hi,
We often have to copy data from one worksheet to another (usually from a
hidden unprotected sheet with DDE links to a visible protected one). Before
we updated (!?) to W2000/XL2000, the obvious kludge of putting
'=othersheet!C20' (etc) in each cell of the visible 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 for a neat solution, but may have missed something.
Does anyone have a 'Range_Copy' macro that's both tidy and understandable to
someone who wants to adapt it to a particular application?
Regards
We often have to copy data from one worksheet to another (usually from a
hidden unprotected sheet with DDE links to a visible protected one). Before
we updated (!?) to W2000/XL2000, the obvious kludge of putting
'=othersheet!C20' (etc) in each cell of the visible 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 for a neat solution, but may have missed something.
Does anyone have a 'Range_Copy' macro that's both tidy and understandable to
someone who wants to adapt it to a particular application?
Regards