LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 162
Default Selection.Autofill Destination:=Range(ActiveCell.Value)

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I autofill combo boxes with their destination cell? Defoes Right Boot Excel Worksheet Functions 3 January 10th 05 12:49 PM
Autofill Destination poppy Excel Programming 5 August 2nd 04 02:03 PM
Help with "Autofill" Destination Range Joe MacPherson Excel Programming 0 May 6th 04 06:03 PM
Selection.Copy Destination:= Mike Fogleman Excel Programming 3 January 10th 04 02:18 AM


All times are GMT +1. The time now is 01:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"