Sub abc()
Range("B23").AutoFill Destination:=Range("B23", ActiveCell)
End Sub


--
Regards,
Tom Ogilvy



wrote in message
oups.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