VB Equivalent of Row(Indirect())

[brainiak4431]

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:

Please Login or Register  to view this content.

[shg]

Welcome to the forum.

Maybe you'll tell us what the formula does, so we don't have to spend the time figuring it out. And post a workbook.

BTW, why not just insert the formula via VBA, and then replace the formula with values?