.FormulaLocal=sum

[methode2404]

Hi,

How can i use "sum" function in ".Formulalocal="
my code in vba :

Range("N" & CStr(ilkbos + 1)).FormulaLocal = "=(R[0]C[-1])+(R[1]C[-1])+(R[2]C[-1])+(R[3]C[-1])+(R[4]C[-1])"

but i would use "sum" function like;

Range("N" & CStr(ilkbos + 1)).FormulaLocal = "=sum(R[0]C[-1]):(R[4]C[-1])"
but it doesn't work

Best Regards
Metin

 

[methode2404]

Many thanks to you Fluff

i have to learn a lot of things.
I'm happy to have people like you in my near on my long way

by the way, sorry for my englisch.

regards
Metin

 

[Fluff]

Glad we could help & thanks for the feedback

 

[methode2404]

Hi,

code works fine ;
Range("N" & CStr(ilkbos + 1)).FormulaR1C1 = "=vlookup(R[0]C[-12],Birimfiyat!r1c2:r102c5,5,false)"

but i must expand this formula. X is integer
i have to add this integer to my formula

i have try;
Range("N" & CStr(ilkbos + 1)).FormulaR1C1 = "=vlookup(R[0]C[-12],Birimfiyat!r1c2:r102c5,5,false)" + X
Range("N" & CStr(ilkbos + 1)).FormulaR1C1 = "=vlookup(R[0]C[-12],Birimfiyat!r1c2:r102c5,5,false) + X "

But it doesn't work.
how can i add a integer to a formula ?

Br,
Metin

 

[RoryA]

Range("N" & CStr(ilkbos + 1)).FormulaR1C1 = "=vlookup(R[0]C[-12],Birimfiyat!r1c2:r102c5,5,false) + " & X

assuming X is a variable.

 

[methode2404]

Many Thanks RoryA, works fine