+ Reply to Thread
Results 1 to 6 of 6

VB Code to get address

  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    VB Code to get address

    Hello:

    Please refer to attached file.
    As you can see i have data in row 4.
    I will have date in Cell K1
    I need VB Code to get me the address to match date in K1 with the date in Row 4.
    In this case it would be cell DK4

    Let me know if you have any questions.
    Thanks.
    Riz
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: VB Code to get address

    Give this code a try
    Please Login or Register  to view this content.

  3. #3
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: VB Code to get address

    It can also be done with a simple formula

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  4. #4
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: VB Code to get address

    Hi :

    JieJenn: I need to make sure that it only looks up in Row 4. So please help code accordingly.
    AllKey: In this case, i need VB Code only...

    Both Thanks a Lot

    Riz

  5. #5
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,835

    Re: VB Code to get address

    Quote Originally Posted by rizmomin View Post
    I need VB Code to get me the address to match date in K1 with the date in Row 4.
    In this case it would be cell DK4
    Are you sure? Isn't it DO4?
    Please Login or Register  to view this content.

  6. #6
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: VB Code to get address

    Hi JieJenn:

    Seems to work for me.
    Will contact if further questions.
    Thanks a lot
    Riz

+ 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. Need more address to be able to trigged from - see code below
    By cagney1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-02-2015, 12:13 PM
  2. Code to search for address via Name
    By lazyengineer in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-09-2015, 02:37 PM
  3. How to get a Zip Code from an address
    By Drgre in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-20-2015, 07:17 AM
  4. Need VBA to look up for ZIP code in address column.
    By winmaxservices1 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-06-2015, 02:29 PM
  5. [SOLVED] Separate Zip Code from Address
    By geddes_3 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 12-13-2013, 07:39 PM
  6. Replies: 1
    Last Post: 03-08-2012, 01:57 PM
  7. How do I put the zip code in the address label?
    By xsell in forum Excel General
    Replies: 1
    Last Post: 12-01-2005, 11:35 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