.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

 

[RoryA]

You can use FormulaR1C1 instead:

Range("N" & CStr(ilkbos + 1)).FormulaR1C1 = "=sum(R[0]C[-1]:R[4]C[-1])"

 

[Fluff]

Hi & welcome to the board.
How about

Range("N" & CStr(ilkbos + 1)).FormulaR1C1 = "=sum(RC[-1]:R[4]C[-1])"

Too slow

 

[methode2404]

Hi,

Thank you for the quick response, works fine.
@Fluff : how can i do it faster ?

regards
Metin

 

[Fluff]

@Fluff : how can i do it faster ?

I mean't that I was too slow, as RoryA had already answered you.

 

[methode2404]

 

[methode2404]

Hi,


I have another formula problem, it's doesn't work.
Range("N" & CStr(ilkbos + 1)).FormulaR1C1 = "=vlookup(R[0]C[-12];sheet1!A2:F101;5;false)"


regards
Metin

 

[Fluff]

try replacing the semi-colons, with commas

 

[methode2404]

Hi Fluff,

my code in vba is :
Range("N" & CStr(ilkbos + 1)).FormulaR1C1 = "=vlookup(R[0]C[-12],Birimfiyat!A2:F102,5,false)"

in cell appears it :
=VLOOKUP(B30;BirimFiyat!'A2':'F102';5;FALSE)

it doesn't work

 

[Fluff]

As you're using R1C1 notation it should be

"=vlookup(R[0]C[-12],Birimfiyat!r1c2:r102c5,5,false)"