Batch Modification of Ranges (Optimization)
 

Hello,

I want to populate a large number of Cells in a workbook that are not
contiguous and on different worksheetsof a workbook.

If they are on the same sheet and contigous I can populate them using
an array in a single call which is faster.

Is there an efficient way if the cells are on different Worksheets and
not contigous? I can do it sheet by sheet by again can it be done in a
single batch call per worksheet?

Tks & Regds
Gap

Batch Modification of Ranges (Optimization)
 

Since a worksheet is a container for range objects a range can not span more
than one worksheet. So you will have to go one sheet at a time. You can
however do non contiguious ranges. Take a look at the union function. It is
about the easiest way to create these.
--
HTH...

Jim Thomlinson


"Gap" wrote:

Hello,

I want to populate a large number of Cells in a workbook that are not
contiguous and on different worksheetsof a workbook.

If they are on the same sheet and contigous I can populate them using
an array in a single call which is faster.

Is there an efficient way if the cells are on different Worksheets and
not contigous? I can do it sheet by sheet by again can it be done in a
single batch call per worksheet?

Tks & Regds
Gap

Batch Modification of Ranges (Optimization)
 

Hello Jim,

Union will help me create the Range but how to populate the resulting
range with values?

Tks & Regds
Gap

Batch Modification of Ranges (Optimization)
 

That depends on what you want to populate the range with. Is it all one
formula or value. Or are there different formulas and values. I need more
infor on exactly what the intention is here.
--
HTH...

Jim Thomlinson


"Gap" wrote:

Hello Jim,

Union will help me create the Range but how to populate the resulting
range with values?

Tks & Regds
Gap