Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I autofill combo boxes with their destination cell? | Excel Worksheet Functions | |||
Autofill Destination | Excel Programming | |||
Help with "Autofill" Destination Range | Excel Programming | |||
Selection.Copy Destination:= | Excel Programming |