Actual code is:
DataSheet.Cells(2, ScratchCol).Resize(EndRow - 1, 1).FormulaArray = "=MIN(IFERROR(SEARCH(Tables_TrustKeywordsWithLeadingSpace,RC" & Format(Owner1Col, "0") & "),999))"
Owner1Col = 2
The actual formula that gets entered in the worksheet is:
{=MIN(IFERROR(SEARCH(Tables_TrustKeywordsWithLeadingSpace,RC2),999))}
But RC2 should have been converted to $Bx (where x is current row number). Why is it not converting to A1-style (as it does correctly with FormulaR1C1)?
By the way, the intent of this formula is to find the first occurrence of any one of a number of keywords (that are in the named range "Tables_TrustKeywordsWithLeadingSpace") within the text in cell $Bx (and return 999 if none of the keywords are found).
Bookmarks