Looking to compare two columns from two different workbooks and return matches, but it seems the code I got from the MS site assumes each column has the same number of rows, while my rows vary. How can I modify this code to allow for variable-length columns? I eventually want it to return the cell directly to the right of the workbook being compared to (Up.Load.Master_20081110.01.xls), but first things first - I need to allow for varying columns. Any suggestions?
From the Microsoft site:
Thanks for any helpPlease Login or Register to view this content.
Bookmarks