| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| Cannot Expand Named Range - when size of the Range exceeds | Excel Discussion (Misc queries) | |||
| How to dynamically reference a dynamic named range | Excel Worksheet Functions | |||
| Reveal cell formats and extendable range in tool/statusbar/icon. | Excel Worksheet Functions | |||
| Define a range based on another named range | Excel Worksheet Functions | |||
Linear Mode
