Hi all,
I have a worksheet that is a summary of another worksheet (both in the
same workbook). I want to copy the summary worksheet and have the
references to a fourth worksheet. However, when I do a simple
edit-replace for the worksheet names, all hell breaks loose. For every
replacement, xl asks for the workbook and worksheet (it would be easier
to manually replace the references). This is most bothersome as it
*seems* that it should be able to just take the new reference and be
done.

So my question is this: Can I replace the sheet reference (not the cell
reference) without xl going nuts?

Thanks, in advance, for any help.