Posts: 281
Threads: 116
Joined: Oct 2010
Reputation:
0
01-20-2012, 01:37 AM
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?
Posts: 424
Threads: 10
Joined: Aug 2011
Reputation:
0
01-20-2012, 06:46 PM
Yes u must first get the row count. You can use usedrange. once you get the number of rows, you can proceed with the comparision.
Posts: 281
Threads: 116
Joined: Oct 2010
Reputation:
0
01-20-2012, 08:50 PM
Ankesh,
Ok, greast but...
How do I do the compaireson of a link name to an entire coulmn of data?
thank you ... ;-)
Posts: 281
Threads: 116
Joined: Oct 2010
Reputation:
0
01-23-2012, 07:39 PM
Wow! Ankesh, thank you.
I will try this and see what happens. I do see that I might need to match up 3 column variables (in one row) to find a value that is unique. but this will help.