Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Copy formulas between workbooks without copying links
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying Sheets between workbooks without links | Excel Discussion (Misc queries) | |||
Copy formulas between workbooks without copying links | Excel Discussion (Misc queries) | |||
Copying formulas between workbooks | Excel Discussion (Misc queries) | |||
Remove formulas and links from 500 workbooks | Excel Programming | |||
Shortcut in copying a formula that links 2 workbooks | Excel Discussion (Misc queries) |