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

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

Hello Jim,

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

Tks & Regds
Gap

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