Page 2 of 2 FirstFirst 12
Results 11 to 16 of 16

Thread: Vlookup Multiple Values By Adding Formula With Loop In VBA

  1. 04-18-2013, 02:00 PM #11
    Safal Shrestha
    Safal Shrestha is offline
    Member
    Join Date
    Jun 2012
    Posts
    39
    Rep Power
    0
    Is the code working with the sheet I have attached? Because it is showing Run time 9 error. Or do I have to change anything in the code?

    Thanx
    Reply With Quote Reply With Quote
  2. 04-18-2013, 02:06 PM #12
    LalitPandey87
    LalitPandey87 is offline
    Senior Member LalitPandey87's Avatar
    Join Date
    Sep 2011
    Posts
    222
    Rep Power
    14
    It is working fine as i already tested it with your attached file.
    There are some constants there you can change it if required.
    Reply With Quote Reply With Quote
  3. 04-18-2013, 02:26 PM #13
    Safal Shrestha
    Safal Shrestha is offline
    Member
    Join Date
    Jun 2012
    Posts
    39
    Rep Power
    0
    Can you please attach the workbook you worked on? Thanks.
    Reply With Quote Reply With Quote
  4. 04-18-2013, 02:35 PM #14
    LalitPandey87
    LalitPandey87 is offline
    Senior Member LalitPandey87's Avatar
    Join Date
    Sep 2011
    Posts
    222
    Rep Power
    14
    I tested it again on your attached file and it is working fine. Restart your system and then check it again may be it will work.
    Reply With Quote Reply With Quote
  5. 04-18-2013, 03:04 PM #15
    Safal Shrestha
    Safal Shrestha is offline
    Member
    Join Date
    Jun 2012
    Posts
    39
    Rep Power
    0
    Sorry for the trouble but again 'subscript out of range'.
    Reply With Quote Reply With Quote
  6. 04-22-2013, 04:49 PM #16
    Safal Shrestha
    Safal Shrestha is offline
    Member
    Join Date
    Jun 2012
    Posts
    39
    Rep Power
    0
    The problem was with the strfindwhat data type. I should have been date datatype. Anyways thanks.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Vlookup to Return Multiple Values
    By Admin in forum Download Center
    Replies: 9
    Last Post: 02-17-2017, 07:03 PM
  2. Loop to two columns and Concatenate values
    By ivandgreat in forum Excel Help
    Replies: 15
    Last Post: 04-14-2013, 08:20 PM
  3. Loop Through And Delete Multiple File Types In A Folder
    By Excel Fox in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 03-30-2013, 04:47 PM
  4. Adding values less than zero
    By Howardc in forum Excel Help
    Replies: 3
    Last Post: 07-14-2012, 11:55 AM
  5. Loop and Check For Values In Entire Column in Excel
    By Jeff5019 in forum Excel Help
    Replies: 3
    Last Post: 05-01-2012, 10:34 PM

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
  •  

Forum Rules