using the formula method

[Overkill32]

I'm trying to automate a process to sort a table and get the sum for a specific column. When I use the .formula = "=sum(A1:A2)", it gives me a "NAME?" error. Any help?

 

[Matty]

Does your formula actually have double quotes, i.e. "your formula" , around it?

Matty

 

[Overkill32]

the line that i wrote is exactly as it was im question with the exception of the cells in the sum formula. it look something like this

ActiveCell.Offset(2, 0).Formula = "=SOMME(K16:K18)"

 

[Matty]

Hi,

Your version of Excel seems to be in a non-English language.

The code you've posted looks OK though. Have you tried recording a macro to see what it spits out?

Matty