You said you have a program written where the column
length changes? Can I assume you know how many cells are
in that column at any given time? If so, just select a
range of cells, then do a fill series on it. Here is an
example.

Range(Cells(1,1),Cells(1,lastRow)).Select
Selection.DataSeries Rowcol:=xlColumns, Type:=xlLinear,
Date:=xlDay,Step:=1, Trend:=False

Does this help?

-----Original Message-----

I was wondering how to change the code, so that the
program
automatically fills the column with numbers, in
chronological order.

I have a macro programmed, where the column length
changes from
document to document, but my autofill only fills it up
until cell 146.
How can I do it so it fills it up beyond 146?


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/

.