VBA to put a formula in cell producess unwanted structured reference

[Bart47]

Hello,

I'm trying to put a sum formula in a cell. The formula has some variables and the result comes with an unwanted '@'

My code:
Dim rowbasis As Integer
rowbasis=Range("D1").Value
Range("M" & rowbasis + 1).Formula = "=som($M$5:M" & rowbasis & ")"

Given that D1 has the value 467, this gives in the cell M468 following:
=@ som($M$5:M467)

I don't want this @. What am I doing wrong?

Kind regards,
Bart

 

[afonsomira]

Hello and Welcome

I tried and it worked for me.

Try:

Dim rowbasis As Integer
rowbasis = Range("D1").Value
Range("M" & rowbasis + 1).Formula = "=sum($M$5:$M$" & rowbasis & ")"

 

[arehman1289]

you wrote the exact same thing ?

 

[afonsomira]

No i change this : Range("M" & rowbasis + 1).Formula = "=som($M$5:M" & rowbasis & ")"
To this: Range("M" & rowbasis + 1).Formula = "=sum($M$5:$M$" & rowbasis & ")"

The right formula is SUM not SOM

 

[Bart47]

Hello and Welcome

I tried and it worked for me.

Try:

Dim rowbasis As Integer
rowbasis = Range("D1").Value
Range("M" & rowbasis + 1).Formula = "=sum($M$5:$M$" & rowbasis & ")"

Works. THANK YOU!
My mistake: I accidently spelled the sum in my mother tongue (som). Since VBA only works in English it was interpreted as a structured reference.
I completeley missed the wrong spelling, but by watching your answer , I immediately saw it. Thanks