AutoFill Question

  • Thread starter Thread starter nkob
  • Start date Start date
N

nkob

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
 
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?
 
Back
Top