+ Reply to Thread
Results 1 to 4 of 4

Repeat a VlookUp for each row in a Macro

  1. #1
    Registered User
    Join Date
    02-06-2014
    Location
    London
    MS-Off Ver
    Excel 2013
    Posts
    63

    Repeat a VlookUp for each row in a Macro

    Hi,

    I am trying to do a vlookup within a macro.

    However this always shows the first result in the first row but the rest of the rows just show #REF.

    I am not sure how to fix this. I want it to look up 100's or rows and shows either the result or N/A


    Once I create the macro this is what the VBA is telling me:


    Please Login or Register  to view this content.

    Any Help would be appreciated.
    Last edited by Chantal4130; 02-06-2014 at 10:05 AM. Reason: Was incorrect

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: Repeat a VlookUp for each row in a Macro

    Please Login or Register  to view this content.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    02-14-2010
    Location
    Scotland
    MS-Off Ver
    MS Office 2013
    Posts
    35

    Re: Repeat a VlookUp for each row in a Macro

    Chantal4130,

    Try pasting this over your existing macro.

    Please Login or Register  to view this content.
    Hope this does the trick

    Stu
    Last edited by stuart010; 02-06-2014 at 12:07 PM.

  4. #4
    Registered User
    Join Date
    02-06-2014
    Location
    London
    MS-Off Ver
    Excel 2013
    Posts
    63

    Re: Repeat a VlookUp for each row in a Macro

    That's Brilliant! It worked Perfectly 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. How to repeat macro until end
    By aeop in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-04-2013, 01:05 PM
  2. [SOLVED] Macro - Repeat macro a specific number of times
    By uvinduds in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-25-2013, 02:42 PM
  3. Repeat a macro
    By VB Nubie in forum Excel General
    Replies: 5
    Last Post: 10-27-2009, 02:50 PM
  4. Replies: 2
    Last Post: 08-24-2005, 12:05 PM
  5. Repeat VLOOKUP formula...
    By benno in forum Excel General
    Replies: 1
    Last Post: 04-21-2005, 08:11 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