vba for lookup and autofill

Hi all, I'm creatinf a vlookup from a column in one shhet to a column in
another, I then want to autofill to the end of the column automatically .
Can anyone help.
Thanks a lot.
--
delmac

You don't give many details, but this sets up a typical formula in B1, and
copies down 100 rows

With Range("B1")
.FormulaR1C1 = "=VLOOKUP(RC[-7],Sheet2!RC[-2]:R[13]C[4],2,FALSE)"
.AutoFill Range("B1").Resize(100)
End With


--
HTH

Bob Phillips

"delmac" <[email protected]> wrote in message
news:[email protected]...
> Hi all, I'm creatinf a vlookup from a column in one shhet to a column in
> another, I then want to autofill to the end of the column automatically .
> Can anyone help.
> Thanks a lot.
> --
> delmac