.FormulaArray - Missing End Curly Bracket - Normal?

[spydey]

So I noticed that when I use .FormulaArray to input an in-cell array formula, in the formula bar I see the formula starts with a curly bracket "{".

But I don't see one on the end.

Normally when I input an array formula via CSE, there is one at the start and one at the end, to identify that it is an array formula entered via CSE (right??).

But when I do it via .FormulaArray, I don't see the end one.

Is this normal/typical?

Or could it be indicative of an error I made along the way in my code?

-Spydey

 

[Fluff]

Try expanding the formula bar, it maybe that your formula is over two or more lines.

 

[spydey]

Try expanding the formula bar, it maybe that your formula is over two or more lines.

So it wasn't that but I sure feel like a dork. lol

I was going line by line, using F8, to ensure that everything was working.

I got down to END SUB and then looked at my formula. It was missing the end curly bracket.

But I just realized that I never finished moving through all lines of code.

END SUB was still highlighted yellow, so the sub hadn't actually finished yet.

I tested it several times trying to figure out the issue, but I must have stopped each time on END SUB and never actually finished the sub.

It is showing now.

I feel pretty ridiculous over something so simple as not finishing the code. hahaha

Thanks again Fluff!

-Spydey

 

[Fluff]

Glad you figured it out & thanks for the feedback