Copy formulas between workbooks without copying links
It sometimes help to do the copy using the fx box at the top of the
worksheet. click on the cell you want to copy. then highlight the formula
in the Fx box and do a copy. then paste the formula in the Fx box in the 2nd
worksheet.
"MCI" wrote:
I want to copy formulas from a range in worksheet A in workbook A to a
range in worksheet B in workbook B.
When i use the clipboard to copy and paste special by formulas, I
often create unwanted external links in workbook B (eg. some names in
workbook B could refer to the ranges in workbook A now).
While i could possible fix this later by looking for the external
links and delete them, I'm looking for a simple way to avoid it.
One possible way is do it in VBA:
workbooks(2).sheets(1).range("A1:A10").formula =
workbooks(1).sheets(1).range("A1:A10").formula
but looks like this only works for non-array formulas
thanks a lot, any help is much appreciated.
|