+ Reply to Thread
Results 1 to 3 of 3

Set value in target range

  1. #1
    Forum Contributor ABSTRAKTUS's Avatar
    Join Date
    04-18-2010
    Location
    England
    MS-Off Ver
    Win10 Excel 2016
    Posts
    609

    Set value in target range

    Hi experts!

    This seems dead easy, yet I struggle to find an answer I'm looking for.

    Assume you have a range where you want to put a value in a single cell within that range. And you also have row & column numbers(on a different sheet) targeting a cell. Example:

    Target information (Row & Column numbers) as well as target value are in sheet "VALUE".
    The range where I want value placed is in sheet "TABLE"

    Basically I want to grab the value and place it in the range where Row and Column meet.

    Can someone please guide me in the right direction how this may be achieved?

    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Set value in target range

    Try this:-
    Please Login or Register  to view this content.
    Regards Mick

  3. #3
    Forum Contributor ABSTRAKTUS's Avatar
    Join Date
    04-18-2010
    Location
    England
    MS-Off Ver
    Win10 Excel 2016
    Posts
    609

    Re: Set value in target range

    Straight on target! A big thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 12-16-2014, 05:47 PM
  2. [SOLVED] Change(ByVal Target As Range) does not work when Target value changes
    By LeonvL in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 01-07-2013, 06:59 PM
  3. [SOLVED] Worksheet_Change(ByVal Target As Range) - set to only update when 3 target cells changed?
    By trillium in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-07-2012, 06:40 PM
  4. Worksheet_CHange (ByVal Target as Range) when target is formula cell
    By coasterman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-09-2012, 07:00 PM
  5. Changing Target Range to A Specific Range
    By bdb1974 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-19-2010, 05:56 PM
  6. Target As Excel.Range or Target As Range
    By Piranha in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-03-2005, 10:49 AM
  7. Ranges:Target in Worksheet_SelectionChange(ByVal Target As Range)
    By Kevin McCartney in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-15-2005, 09:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1