Thanks Tom! That worked great and it did everything it was suppose to
do...however it is filling the rows down to the code even replacing the
code with the VLOOKUP fill down. Is there a way to stop this from
happening? I suppose I could write another macro to delete the
un-wanted fill down but I figured there would be a better way to stop
it?


Tom Ogilvy wrote:
> Sub abc()
> Range("B23").AutoFill Destination:=Range("B23", ActiveCell)
> End Sub
>
>
> --
> Regards,
> Tom Ogilvy
>
>
>
> <Shaka215@gmail.com> wrote in message
> news:1145763913.425458.192100@g10g2000cwb.googlegroups.com...
> > Hi there! New to posting messages on the board however, I am an avid
> > user of reading other peoples questions and figuring out answers from
> > their questions. I came into an interesting problem with getting Excel
> > to do something pretty basic. I need Excel to select a cell and insert
> > the value of that cell (will be a range), into the code...look below.
> >
> >
> > Range("B23").Select
> > "Selection.Autofill Destination:=Range(ActiveCell.Value)"
> >
> > Cell B23 [ VALUE: "B3:B22" ] - will change quite often and the autofill
> > is copying a Vlookup code down to the end of the range. I need this
> > because I am trying to get a spreadsheet to udpate VLOOKUP codes when
> > ever a new item is inserted into this program I am designing. Please
> > assist!!
> > Thanks!
> >
> > Todd
> >
> > LordTodd215@hotmail.com
> >