Can seem to find an issue like this on google.
I just don't understand.
Receiving a runtime error 1004 which highlights the second code snippet below.
"Application-Defined or Object-Defined error"
This works:
Formula:
ws.Range("A16").Value = "=IF(G16=""X"",IF(SUMPRODUCT(--(NOT(ISERR(SEARCH($A$2:$A$15,B16)))))>0,""X"",""N""),""N"")"
ws.Range("A16").Copy
ws.Range("A17:A1500").PasteSpecial Paste:=xlPasteFormulas
This doesn't work:
Formula:
ws.Range("E16").Value = "=TRIM(CONCATENATE(LEFT(B16,FIND("","",B16)-1),"" "",MID(B16,FIND("" "",B16)+1,FIND("","",B16)))"
ws.Range("E16").Copy
ws.Range("E17:E1500").PasteSpecial Paste:=xlPasteFormulas
The 2nd code is directly following the first.
Any ideas?
Bookmarks