+ Reply to Thread
Results 1 to 3 of 3

Issue with Target.Address

  1. #1
    Registered User
    Join Date
    03-07-2018
    Location
    Michigan
    MS-Off Ver
    2016
    Posts
    2

    Issue with Target.Address

    SOLUTION: Sub had to be named "Worksheet_Change" for this to work.

    I'm trying to get excel to auto-fill in multiple sheets when one cell in one sheet is updated. I was planning on using the Target.Address function to do this.
    However, I can't for the life of me get this to work. I have the following test code in the sheet's code:
    Please Login or Register  to view this content.
    I have also tried using
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    None of which were succesful.
    I am working in a Macro Enabled workbook, but excel will never display the message box to me no matter how many times I update B19.
    Please let me know of any further information I need to provide, and thank you in advance for any help you can offer.
    Last edited by NewBoard; 03-07-2018 at 12:47 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    11-28-2015
    Location
    indo
    MS-Off Ver
    2016 64 bitt
    Posts
    1,272

    Re: Issue with Target.Address

    Dont understand what you want
    Target.address = [B19].address
    Or
    Target.address(0,0) =[B19]
    "ThankyouFor Attention * And Your Help!!"

  3. #3
    Registered User
    Join Date
    03-07-2018
    Location
    Michigan
    MS-Off Ver
    2016
    Posts
    2

    Re: Issue with Target.Address

    Dont understand what you want
    Target.address = [B19].address
    Or
    Target.address(0,0) =[B19]
    I want excel to realize I've updated a cell, and then update other cells with that same information. The code I've appended to this post is just test code to see if I can get the listener to work.
    The formats you posted did not work either.
    Last edited by NewBoard; 03-07-2018 at 12:29 PM. Reason: Tested Formats

+ 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. [SOLVED] how to make my code work with target.column instead of target.address
    By dmcgov in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-18-2017, 09:29 AM
  2. Target.Address Help
    By TSHolland in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-20-2015, 11:26 AM
  3. [SOLVED] Target.Address issue
    By Aris in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 06-12-2014, 06:24 AM
  4. [SOLVED] If Target.Address
    By jordan2322 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-05-2012, 07:36 PM
  5. Target.Address help
    By gth667h in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-02-2010, 05:54 PM
  6. Target.address
    By esullivan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-09-2010, 09:36 AM
  7. Target.Address issue
    By captedgar in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-08-2010, 11:03 AM

Tags for this Thread

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