How to get formula relative specify cell?

[Khanh]

From this photo,

I want to find the corresponding formula at E4.
The usual implementation that I know of is Copy B4 then paste E4.
The desired result is =SUM(E2:E3)

My question is: Based on the formula in B4, and the rows and columns spacing parameters (here between E4 and B4: rows=0 and columns=3).
Can I define the formula at E4?

Thanks you!

 

[RoryA]

I don't really follow, but perhaps you mean

=SUM(OFFSET(B2:B3,0,3))

?

 

[Khanh]

I don't really follow, but perhaps you mean

=SUM(OFFSET(B2:B3,0,3))

?

Hi, Thanks for the reply and formula.
Can I achieve this formula by code? such as:

Dim a string 
a= Range("B4").formula 
Dim rowsas integer :rows=0
Dim columns as integer:columns=3
Dim result as string 
...

to get result formula at E4 is "=Sum(E2:E3)"
(I need to calculate it without affecting the spreadsheet. )

 

[RoryA]

I need to calculate it without affecting the spreadsheet.

What exactly does that mean?

 

[Khanh]

What exactly does that mean?

Hi, I mean not put any values on the spreadsheet. such as
Range("B4").copy.
Range("E4").pastevalue (this put temporary value to cell)
I have another example:
At `B4 "=B2+B3" `
The desired formula at `E4 "=E2+E3"`

 

[RoryA]

If you want the same formula in E4 as B4, why can't you just copy it? Or simply use something like Range("E4").FormulaR1C1 = Range("B4").formular1c1?

 

[Khanh]

If you want the same formula in E4 as B4, why can't you just copy it? Or simply use something like Range("E4").FormulaR1C1 = Range("B4").formular1c1?

Hi,
I hadn't thought of this formula.
Exactly what i need. Thanks very much!