BVA code act differently in 2 different woorkooks

Hello all,

gmk from this form shared some code for populating an array from a sheet and then searching that array to find the row that contains the desired value. The code he shared works great.

Once I was able to determine which row contains the desired value I was able to capture the cell values from that row.

Originally all of the data needed would be in one workbook, one sheet. Then I had to change the design to capture data from two different workbooks. I replicated the code for the second workbook and everything is working as expected.

Then I copied that code into a very complex workbook whose macros are contained in external text files so that the template that our end users are using will not have to change when we want to change the macros.

When I copied the code from the test workbook into the macro files, only the first file search was successful. Does anyone see see any problem with the code and perhaps have an explanation of what I need to change?

Thanks
Bruce

Please Login or Register  to view this content.