This returns the correct range for my index. It basically sets the index range to look in the worksheet from the first instance of a value (that is in A142) to the last instance. So If A142 is on the worksheet 4 times, and the first time it shows up is row 100 - the range is set for AccesoriesCust!H100:I104Please Login or Register to view this content.
BUT that gives thousands of Indirect() - need to have VBA .functionetc...Please Login or Register to view this content.
If I could get the find to work that would give the start of the range, and add a count of the number of A142's in the range would give the end of the range.
Any help would be appreciated.
Bookmarks