ERROR SET CELL VALUE - MS EXCEL VBO

[rudyfritz]

Good evening, I would like to help me with this problem I have, I am working with an excel file which has 2 columns with numerical data and in the third column I want to calculate the sum of both rows, for this I am working with Set Cell Value of MS Excel VBO, in the value I'm placing the formula that would be like this: "= SUM (A1; B1)" and running the application I get an error that I sent, if I remove the character = there is no problem, apparently not is recognizing said character in the formula.

I would like you to help me with this issue that is taking me many hours and I can not find the error.

Thank you.

 

[sivagelli]

"= SUM (A1; B1)"

Ideally excel accepts colon in range of cells, formula has to be "=SUM(A1:B1)", you have got semi colon in place of colon on the excel formula. That is causing the trouble.

 

[rudyfritz]

Ideally excel accepts colon in range of cells, formula has to be "=SUM(A1:B1)", you have got semi colon in place of colon on the excel formula. That is causing the trouble.

Thank you very much for the help and verify it and if it works that way.