Range
 

Dear All,

I am exporting data ( table) from SQL to Excel.
I want to export a formula column, where I can specify the range in Code:
what is the similar/equivalent code to: =B(Row()) + A(Row() +1)??
[Is there an Eval function in MS Excel?]

Thanks.
jouj

Not quite sure, but are you trying to get the values in cells Bn & Am? if so

=INDIRECT("B"&ROW()) + INDIRECT("A"&ROW()+1)

--
HTH

Bob Phillips

"jouj" wrote in message
...
Dear All,

I am exporting data ( table) from SQL to Excel.
I want to export a formula column, where I can specify the range in Code:
what is the similar/equivalent code to: =B(Row()) + A(Row() +1)??
[Is there an Eval function in MS Excel?]

Thanks.
jouj

Thank you.
jouj

"Bob Phillips" wrote:

Not quite sure, but are you trying to get the values in cells Bn & Am? if so

=INDIRECT("B"&ROW()) + INDIRECT("A"&ROW()+1)

--
HTH

Bob Phillips

"jouj" wrote in message
...
Dear All,

I am exporting data ( table) from SQL to Excel.
I want to export a formula column, where I can specify the range in Code:
what is the similar/equivalent code to: =B(Row()) + A(Row() +1)??
[Is there an Eval function in MS Excel?]

Thanks.
jouj