Okay, now Jim and Gord are my most favorite people in the land! You have
made my day!
THX.

"Gord Dibben" wrote:

Doesn't take too long to drag A5 down to A2000.

But you can select A5 and in the namebox type A5:A2000ENTER

Then CTRL + D to copy down.


Gord Dibben MS Excel MVP

On Fri, 25 Sep 2009 11:50:03 -0700, vtrud
wrote:

Yep, I get how to do that but I don't want to do this all the way up to 2000.
Easier way to auot fill or something?

"Jim Thomlinson" wrote:

One way...

In A1 1000
In A2:A4 =A$1
In A5 =A1+1
Drag the formula in A5 down as necessary.
--
HTH...

Jim Thomlinson


"vtrud" wrote:

I would like to fill a column with progressive numbers in sets of 4 each.
For instance, A1 - A4 will have 1000 in them then A5-A8 will have 1001 and so
on.

Ideas?
Thx, V