macro
 

I'm using macro to move some Excel sheets (containing link
function) to another opening Excel file. but after the
move/copy sheet, i found the links was not right, as a
result, it show me the wrong data! What i have to do is
run the link function after i move/copy(using macro)the
sheet, than the data link is correct.
Is this the MUST procedure?
i tried to change the "reference style" to C1R1, but the
problem still occour.
Anyone can help? pls.

macro
 

Hi Eugene,
Can't tell what the problem is but I am guessing that you
have some sheets that have links to each other. You want
to copy those sheets together as a group.

Group the sheets you want to copy using the Ctrl key to add
more sheets to the group, then copy all the sheets at once
as you were copying one sheet before.

After you have done your copy, you must ungroup the sheets,
as any change to the visible sheet will be made to all sheets in
the group which would usually do a lot of irreparable damage.
Ungroup by selecting a cell outside the group, or by right clicking
on the worksheet tab and using Ungroup sheets. --
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Eugene" wrote in message ...
I'm using macro to move some Excel sheets (containing link
function) to another opening Excel file. but after the
move/copy sheet, i found the links was not right, as a
result, it show me the wrong data! What i have to do is
run the link function after i move/copy(using macro)the
sheet, than the data link is correct.
Is this the MUST procedure?
i tried to change the "reference style" to C1R1, but the
problem still occour.
Anyone can help? pls.