On Tue, 13 Jul 2004 14:38:10 -0700, Gord Dibben <gorddibbATshawDOTca
wrote:

One method of populating a column with numbers is to enter 1 in top cell.

Right-click on fill handle of the this cell and drag down 100 rows.

Release the button and select "Fill Series" from the menu.

Oh, god, to think of all these years when I've been typing all the
numbers in manually! <lol

(Told yas I was a newbie even if a power user! D'uh! <g)

Unbelievably easy! This worked just fine. The method below would be
best if I knew ahead of time what the beginning and end cells would
be. I see a use for both methods.

Thank you so much for this! <g

Another method is to enter 1 in the top cell, select the namebox and type in
A1:A100 and <ENTER (A1:A100 to be adjusted to your range and column)

Now, EditFillSeriesLinearOK

If you need numbers later past 100, just select 99 and 100 and drag/copy down.

Gord Dibben Excel MVP

On Tue, 13 Jul 2004 16:43:30 -0400, "StargateFanFromWork"
wrote:

This is something I've run across again and again that I hope to now get a
solution for. Most of the time, I use =ROW-1, or a variation thereof, to
get column A to show numbers 1 to whatever, depending on the # of rows in a
print area.

However, every once in a while numbers _must_ still display sequentially,
but must be "real" numbers. So instead of =ROW-1 showing in a cell, one
would see an actual #, 1, 2, 3, 4 ... etc. I've always had to type these in
manually. Today I had to type in up to row 100!

My question is if it's possible to programmatically dump the numbers in in a
selected number of cells downwards in column A?? i.e., if I were to select
from A2 to A51, for example, could the macro start filling in the cells
numerically - A2 would then have a 1 in it, A3 would have 2, A4 would have
3, etc., etc.?

This would be a god-send, if it were possible to do.

I just got to thinking, what if the case were of running out of rows in a
spreadsheet? Let's say a sheet that reached row #A51 which had number 50 in
it. I'd have to add rows after that point. If I added 50 more rows and
then selected A52 to A101, would there be a way to have the macro then
populate the cells from 51 to 100? To do both, starting from 1 like the
above case, or starting from 51 like this second case, I'm guessing it would
be a matter of prompting the user for the starting number to begin the
numbering (?).

Just a thought. I don't know if this can be done, but it would save so much
grief and time and would save some poor fingers! <g

Thanks!