Range

G

Guest

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)
 
G

Guest

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Naming a Data Range 2
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
Excel VBA - counting cells by colors and names to it in two different rows. 0
Increasing columns 1
Export range to text file 1
Excel VBA - Problem with Closing Print Preview 0
VB Macro Problem 1

Top