hi I have a array which take the value from the column J. izit possible to have a check in column B. If one of the value in column J was founded in column B(cell B3:B50), it will not put the value into the array.
Please Login or Register to view this content.
You can use the Find method to try to locate a given value from col J in the range of interest in col B. If you find it, don't add it to the array.
Entia non sunt multiplicanda sine necessitate
how to use the find method in my example? or is there any example for me to refer to ?
Last edited by kaffal; 03-29-2009 at 06:35 AM.
Hope this will help you
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks