J
Jeff
Hi,
I am copying formulas from Workbook1 to workbook2.
Here is the problem - formulas still reference the old workbook1.
like: Cell(A1) = '[Workbook1.xls]worksheet'!E3
But I really don't want the "Workbook1.xls" I just want
Cell(A1) = worksheet!E3
Thanks!
I am copying formulas from Workbook1 to workbook2.
Here is the problem - formulas still reference the old workbook1.
like: Cell(A1) = '[Workbook1.xls]worksheet'!E3
But I really don't want the "Workbook1.xls" I just want
Cell(A1) = worksheet!E3
Thanks!