Macro to Formula

[Roy]

for example:
A1
50
40
17
=sum(A2:A4) '(Use VBA Build)

Thank you !

 

[ozgrid.com]

What's you question? Your subject and body contradict each other.

 

[FSt1]

hi
several ways
using select.....
using R1C1 reference....
ActiveCell.FormulaR1C1 = "=SUM(R[-4]C:R[-1]C)"
using nonR1C1 reference....
Actrivecell.Formula = "=SUM(A1:A4)"
NOT using select....
Range("A5").Formula = "=SUM(A1:A4)"
Cells(5, 1).Formula = "=SUM(A1:A4)"

the non select method can use the R1C1 reference style.

Regards
FSt1

Regards
FSt1