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

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