I have a set of link names that I have copied into column D of one Excel spreadsheet.
If the column D of #1 Excel spreadsheet matches any of the values in column E of #2 Excel spreadsheet, the link name is Ok to be used.
How is the search of an entire column possible? Must I know how many rows there are?
Thx for the help ;-)
You can store the column data for both the columns D of file 1 and E of file 2 as arrays. Then simply compare the two 1-Dimensional arrays.
Mansoor QTP Inside Out