Fill range with incremental numbers

Hello Jaymond Flurrie,

You can do this a couple of ways. The easiest way is to use the For Each Next loop. This will automatically index through all objects in the collection, in this case your range rng.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Jaymond,

I would have close this thread if I had seen it first. Please read the Forum Rules about thread titles before starting your next one.

Originally Posted by mikerickson

Here's a non-looping method

Please Login or Register  to view this content.

I understood that this is pretty fast, right? I mean, it doesn't use loop and uses worksheet formulas, which both should be always used when possible, right?

Originally Posted by shg

Jaymond,

I would have close this thread if I had seen it first. Please read the Forum Rules about thread titles before starting your next one.

So it should have been for example "Fill range with incremental numbers"? I will remember this next time. Sorry for bad title.

Originally Posted by mikerickson

Jaymond,
You will have to do some testing on typical ranges for your needs.
Normally loops are slower, but array formulas are notoriously very slow. I tried to minimize the size of the arrays involved, but your testing would be the best judge.

Does it depend about CPU at all? I mean, does dual-core count something faster than "classic" CPU?

Originally Posted by Jaymond

So it should have been for example "Fill range with incremental numbers"?

That would have been much better, thank you.

The objective is to create a searchable database. In addition, I think you'll find that people are more willing to look at, and respond to, threads that have a concise title and well-stated problem.