Range.FormulaArray - R1C1 formula in A1-style worksheet doesn't work??

I'm using Range.FormulaR1C1 and Range.FormulaArray in an A1-style worksheet to create formulas in certain ranges.

FormulaR1C1 works fine: If the formula for cell F12 includes "RC2", then the actual formula (as displayed in the worksheet) will show "$B12" in its place.

The problem is FormulaArray. The documentation says one MUST use R1C1 notation when assigning a formula using FormulaArray. Yet when my formula contains "RC2" (and gets plugged into the A1-style worksheet) the cell reference does not get "translated" to A1 format. It still shows "RC2" (instead of, for example, $B12), which therefore refers to the WRONG CELL.

So how do I fix this? Do I have to do something like:

Please Login or Register  to view this content.

Actual code is:

Please Login or Register  to view this content.

Owner1Col = 2
The actual formula that gets entered in the worksheet is:

Please Login or Register  to view this content.

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).

Already tried that. Still doesn't work. Even just pasting the formula into a single cell, the "RC2" reference remains unchanged.

The formula works correctly (and indeed returns the correct value) if I enter it manually (or simply change RC2 to $B2 so it references the correct cell). I just don't know why it doesn't get converted from RC2 to $B2 when it's entered using FormulaArray.

Originally, I set this all up by manually entering the formula and confirming that everything worked OK. I then coded the macro to duplicate what I had done manually. But for some reason the "required" R1C1 format doesn't get converted to A1-style.

Well, it appears that the Excel documentation (or the actual implementation) is wrong. Just tried this (on a test sheet, where the data is in cell H26):

Please Login or Register  to view this content.

If I stop the macro before changing back to A1 style, the actual formula in cell O26 is:

Please Login or Register  to view this content.

So it looks like FormulaArray is treating RC8 as an A1-style reference, in spite of what the documentation says!

Ran a few more tests and found (if Excel is left in A1 mode):
• FormulaArray using "RC8" results in actual formula containing "RC8" (incorrect)
• FormulaArray using "H26" results in actual formula containing "H26" (correct! But contradicts the documentation!)
• FormulaArray using "R[]C8" results in actual formula containing "H26" (CORRECT!)
So apparently, FormulaArray interprets formulas with no brackets as being A1-style, while formulas that include any brackets are interpreted as R1C1 style.