How to transfer the length of one column to a formula in Visual ba

Thanks.
This works alright except that I have further data in cells J102-J106 which
now get overwritten. I only want to fill the cells in Column J which
correspond to the number of cells I have in Column A, no more and no less.

"DMoney" wrote:

>
> Selection.AutoFill Destination:=Range("j2:j"
> &ActiveSheet.UsedRange.Rows.Count)
> "Kanga 85" wrote:
>
> > I have a column A of variable length (say 100 cells). I have a formula in J2
> > which I wish to pull down for that number of cells.
> >
> > Range ("J2").Select
> > Selection.Autofill Destination:=Range("J2:J101"), Type:=xlFillDefault.
> >
> > How do I get the length of Column A to replace the term 'J101' in this
> > formula?
> >
> > Thanks

Kanga 85,

Did you try my suggestion? This finds the last used cell in Col 1 (Col A) and copies your formula down to the corresponding row in Col J.