Hello,
it would be good if i can get assistance for both the methods.
1. The below function works but it gives an (vba) error message if a match is not found. can this be avoided (without using On error)
2. what would be equivalent code for the above using evaluate+match combination ( Note: i would like to retain the search criteria - Range("a1:z1") - as it is and do not want to define it as a range / set as a range.Please Login or Register to view this content.
Thanks
Bookmarks