+ Reply to Thread
Results 1 to 4 of 4

vba code to pull some info from address if a word is present in description.

  1. #1
    Registered User
    Join Date
    05-28-2016
    Location
    Boston, Mass
    MS-Off Ver
    2016
    Posts
    2

    vba code to pull some info from address if a word is present in description.

    I'd like to be able to contact info and create a list with some of the information from the physical and mailing addresses if a certain word is present in the description. I have some code but I am having an issue with it getting an error (object variable not set), can't seem to figure out what it could be. Any ideas?

    Please Login or Register  to view this content.

  2. #2
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: vba code to pull some info from address if a word is present in description.

    Kire14,
    Welcome to the forum!
    I'm not sure, but it doesn't look like you haven't set the rngCell. Also you have InStr, which isn't defined and/or set.
    Edit* I just noticed you have lngLoop that isn't declared and/or set.
    Last edited by gmr4evr1; 05-28-2016 at 03:24 PM.
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom

  3. #3
    Registered User
    Join Date
    05-28-2016
    Location
    Boston, Mass
    MS-Off Ver
    2016
    Posts
    2

    Re: vba code to pull some info from address if a word is present in description.

    Thanks for the help, I'm looking into it a bit. I had someone write this for me as I am just in the extreme early stages of vba programming.

  4. #4
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: vba code to pull some info from address if a word is present in description.

    No problem and good luck. Wish I could have been able to guide you a little better, but I'm not sure (yet) how and/or when to declare certain things or what to set them as. Although, for the rngCell, since it's declared as Range, you'll want something that gives the range of cells you want to use I.E.
    Please Login or Register  to view this content.
    This could be totally wrong, but that is what I would try for that. Even though I have been doing/using VBA for over a year, I still have a lot to learn.

+ 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] Pull zestimate from zillow with address and zip code
    By tiderider03 in forum Excel Programming / VBA / Macros
    Replies: 62
    Last Post: 09-26-2020, 03:56 PM
  2. VBA pull info from word userform to excel worksheey
    By wannabeexcelguy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-09-2016, 04:22 PM
  3. [SOLVED] Pull stock code , description and pack from sheet1
    By makinmomb in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-14-2014, 03:23 PM
  4. Replies: 2
    Last Post: 07-22-2014, 07:44 AM
  5. [SOLVED] Retrieving description from another doc based on item number present
    By Rev4HP in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-15-2013, 10:13 PM
  6. Macro code to pull cell info into .csv file
    By newbie10 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-30-2012, 11:53 AM
  7. VBA Code to pull info onto Userform
    By Climaxgp in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-15-2009, 07:00 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