Excel Issue

[arbo80]

Hi all,

I have an Excel workbook with multiple sheets (let's call it A). a cell in Sheet1 is getting its value from a cell in Sheet9. there is a batch file that copies all those sheets to a different workbook (B) and the problem is that when I check the values of the cell in the new workbook (B), they reference to the old workbook (A). Is there anyway that I can change that so that I get the proper values (the ones that are in the same workbook but different sheets).

Thanks,

J.

 

[SkipVought]

Hi,

Edit > Replace

Skip,

_{Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty!}