Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Range with no formal updates
I want to copy a range of cells A1:D4
I want to paste them in an adjacent range E1:H4. The first array contains formulas that are not absoluted. I want to copy the array in such a way that it gets pasted without the formula ranges updating. The simle answer to this would be to absolute them before you copy them. The ole F4 trick in the formula bar However I really want to copy multiple arrays into new multiple target arrays. And the formulas in the copy arrays are all different. I Almost need a new option in the past-special dialogue box that states "past formulas without dynamic updating". Is there an option like this in excel or a routine in VBA? Thanks TS |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Range with no formal updates
Terry,
Range("E1H4").Formula = Range("A1:D4").Formula Doesn't matter if formulas are absolute or relative. -- sb wrote in message om... I want to copy a range of cells A1:D4 I want to paste them in an adjacent range E1:H4. The first array contains formulas that are not absoluted. I want to copy the array in such a way that it gets pasted without the formula ranges updating. The simle answer to this would be to absolute them before you copy them. The ole F4 trick in the formula bar However I really want to copy multiple arrays into new multiple target arrays. And the formulas in the copy arrays are all different. I Almost need a new option in the past-special dialogue box that states "past formulas without dynamic updating". Is there an option like this in excel or a routine in VBA? Thanks TS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how i dow the following formal in excel | Excel Discussion (Misc queries) | |||
convert formal from excel to access | Excel Worksheet Functions | |||
Conditional Formal not working | Excel Discussion (Misc queries) | |||
Need Help on formal - output a sum | Excel Worksheet Functions | |||
My chart automatically updates, but how can i keep it within a static date range???? | Charts and Charting in Excel |