Can anyone help please. I have never come across this problem and do not know how to get past it. (apologies if i'm writing a bit long winded but am finding it hard to explain)
I have a formula which displays "MATCH", when a cell contains a value
eg =IF(ISNUMBER(SEARCH($E$1,A1)), "MATCH", "NO")
$E$1 being the value, searching in A1
$E$1 is a value from another workbook. When i run a macro, it opens a workbook, copies a value into E1 and searches for the value in the current worksheet in the adjacent cell, then repeats again. it does this multiple times running through different workbooks
the problem i am having is that sometimes the copied value cannot be found with the formula, and it still returns "NO". I have formatted the new value to suit the workbook, re formatted the whole worksheet, etc.. but nothing happens. The only way the number can be found is if I manually type the value in.
This is not happening with all of the copied values. Mostof the time i'm copying multiple values from the same workbook and only one value cannot be read.
thankyou in advance
paul
I have a formula which displays "MATCH", when a cell contains a value
eg =IF(ISNUMBER(SEARCH($E$1,A1)), "MATCH", "NO")
$E$1 being the value, searching in A1
$E$1 is a value from another workbook. When i run a macro, it opens a workbook, copies a value into E1 and searches for the value in the current worksheet in the adjacent cell, then repeats again. it does this multiple times running through different workbooks
the problem i am having is that sometimes the copied value cannot be found with the formula, and it still returns "NO". I have formatted the new value to suit the workbook, re formatted the whole worksheet, etc.. but nothing happens. The only way the number can be found is if I manually type the value in.
This is not happening with all of the copied values. Mostof the time i'm copying multiple values from the same workbook and only one value cannot be read.
thankyou in advance
paul
