Hi everyone,

I am wondering what the VB Equivalent of Row(Indirect()) is. Both are not supported in VB but are excel functions. I know that the indirect function is mainly to combine strings together and I think this is easy to overcome in VB by adding the & between strings. But how do I overcome the ROW function, which I believe is to place things into an array.

Basically what I am trying to do is convert and excel array formula into a VB macro. Can you convert the Row(Indirect()) parts of the formula?

The forumla is below:
=MID(RC[1], LEN(RC[1]) - MATCH(""("", MID(RC[1], LEN(RC[1]) - ROW(INDIRECT(""1:"" & LEN(RC[1]))) + 1, 1), 0) + 2, MATCH(""("", MID(RC[1], LEN(RC[1]) - ROW(INDIRECT(""1:"" & LEN(RC[1]))) + 1, 1), 0) - 2)