Range

J

jouj

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
 
B

Bob Phillips

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

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

jouj

Thank you.
jouj

Bob Phillips said:
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 said:
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
Click to expand...
Click to expand...
 
Top