adding and dividing with vba code in excel for sheet val change

[ssbhatban]

Dear Friends

I am writing fe programs in excel in VBA & i want to use this formula BY VBA coding.
=SUM(F2:H2)
for the columns F and H

can any body help

thanks in advance

[berlan]

try,

Range("A1").Formula = "=SUM(F2:H2)"

or

Range("A1").Value = Application.Sum(Range("F2:H2"))

and change cell A1.

[ssbhatban]

Dear Friend

thank you.

i am new to coding

i am working in a sheet under this

Private Sub Worksheet_Change(ByVal Target As Range)

now almost all my work is finished and i cannot insert any new column or change. my column A is already used & all the columns up to X

i want my result in column I

can u suggest

with regards

[ssbhatban]

Dear Friend

thank you.

i am new to coding

i am working in a sheet under this

Private Sub Worksheet_Change(ByVal Target As Range)

now almost all my work is finished and i cannot insert any new column or change. my column A is already used & all the columns up to X

i want my result in column I

can u suggest

with regards