How to build an Excel formula with offsets

[fredjonze]

Hi,

Is there a way to build a formula using the Excel range.offset function? My experiments so far have created a formula like...

=123+456

Instead of what I want...

=B4+B7

I need to return a column/row reference instead of the value in the cell. Since I'm building the spreadsheet dynamically I don't really know the columns that will contain the target refrences so it is difficult to use the "=B" & cstr(lCurrentColumn + 3) kind of formula builder.

Any hints or ideas are appreciated.

 

[JGillespie]

address function may help

Jamie Gillespie
j-gillespie@s-cheshire.ac.uk

 

[PHV]

Take a look at the Address, Formula and FormulaR1C1 property of the Range object.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884