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

I have a macro programmed, where the column length changes fro
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

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/

.

paste your code into a text message...

In article ,
nkob wrote:

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?