Results 1 to 15 of 15

Iterations with a Vlookup UDF

Threaded View

  1. #1
    Registered User
    Join Date
    06-13-2011
    Location
    Boulder, Colorado
    MS-Off Ver
    Excel 2010
    Posts
    61

    Iterations with a Vlookup UDF

    Hey all,

    I have done a fair share of vba programming and am familiar with a lot of the capabilites but am very much a novice in certain areas of programming. One of them would be interations with for loops. I have many sets of data which I am analyzing via various macros that perform different functions. Currently where I need help is with integrating a UDF to find all matches in a data range using Vlookup. This search is based off frame number and reports all of the x-coordinates found in the frame number. However, I'm almost positive to get this program to run dynamically in a macro it needs to be part of a for loop to detect and iterate through any number of frames a data set may contain. I've posted an example workbook to make things a little easier to visualize. As always feel free to ask questions and also any suggestions to reformat and clean up the UDF output would be greatly appreciated.
    Attached Files Attached Files
    Last edited by Impartial Derivative; 07-01-2011 at 01:45 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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