macro-written correct formula returns #NAME? and #VALUE?
 

Hello. I'm having troubles writing an excel 2003 macro. I'm using a
line like
Worksheets("ctacte").Range("C" & c) = "=SUMA($C$" & s & ":$C
$" & (c - 1) & ")" <<
to write the formula =SUMA($C$11:$C$12) to a cell in the "ctacte"
worksheet. (SUMA instead of SUM because I'm using a spanish version of
excel).
Problem is, when the macro finishes running, the cell, instead of
returning the value of the sum I get a #NAME? error. The odd thing
here is that if I press F2 and then ENTER on the cell, I get the
correct result. The formula doesn't get autocorrected of anything, it
is exactly the same thing that the macro returns. Only that to get the
result I need to F2-ENTER it!

Any idea of what the problem would be? I'd really appreciate it!

Thanks and forgive my bad english!

macro-written correct formula returns #NAME? and #VALUE?
 

check
Tools, Options, Calculations - is it set on automatic or manual?
sometimes in a macro automatic gets set to manual & then we forget to
change it back......... next time excel opens it will be on manual
without anything being done.
hth!
susan



On Apr 9, 11:43 am, "s.a." wrote:
Hello. I'm having troubles writing an excel 2003 macro. I'm using a
line like
Worksheets("ctacte").Range("C" & c) = "=SUMA($C$" & s & ":$C
$" & (c - 1) & ")" <<
to write the formula =SUMA($C$11:$C$12) to a cell in the "ctacte"
worksheet. (SUMA instead of SUM because I'm using a spanish version of
excel).
Problem is, when the macro finishes running, the cell, instead of
returning the value of the sum I get a #NAME? error. The odd thing
here is that if I press F2 and then ENTER on the cell, I get the
correct result. The formula doesn't get autocorrected of anything, it
is exactly the same thing that the macro returns. Only that to get the
result I need to F2-ENTER it!

Any idea of what the problem would be? I'd really appreciate it!

Thanks and forgive my bad english!

macro-written correct formula returns #NAME? and #VALUE?
 

Hi S,

Try replacing the Spanish funtion SUMA with the
Englsh equivalent Sum.

Excel will automatically translater the function into the
user''s version language.


---
Regards,
Norman


"s.a." wrote in message
oups.com...
Hello. I'm having troubles writing an excel 2003 macro. I'm using a
line like
Worksheets("ctacte").Range("C" & c) = "=SUMA($C$" & s & ":$C
$" & (c - 1) & ")" <<
to write the formula =SUMA($C$11:$C$12) to a cell in the "ctacte"
worksheet. (SUMA instead of SUM because I'm using a spanish version of
excel).
Problem is, when the macro finishes running, the cell, instead of
returning the value of the sum I get a #NAME? error. The odd thing
here is that if I press F2 and then ENTER on the cell, I get the
correct result. The formula doesn't get autocorrected of anything, it
is exactly the same thing that the macro returns. Only that to get the
result I need to F2-ENTER it!

Any idea of what the problem would be? I'd really appreciate it!

Thanks and forgive my bad english!

macro-written correct formula returns #NAME? and #VALUE?
 

Unbelievable, but it worked. I forgot to mention it earlier, but
pressing F9 ("Calculate now" or whatever it is called in english)
didn't do anything, and calculations were always set to Automatic.

Why would this happen?

On Apr 9, 1:05 pm, "Norman Jones"
wrote:
Hi S,

Try replacing the Spanish funtion SUMA with the
Englsh equivalent Sum.

Excel will automatically translater the function into the
user''s version language.

---
Regards,
Norman

"s.a." wrote in message

oups.com...

Hello. I'm having troubles writing an excel 2003 macro. I'm using a
line like
Worksheets("ctacte").Range("C" & c) = "=SUMA($C$" & s & ":$C
$" & (c - 1) & ")" <<
to write the formula =SUMA($C$11:$C$12) to a cell in the "ctacte"
worksheet. (SUMA instead of SUM because I'm using a spanish version of
excel).
Problem is, when the macro finishes running, the cell, instead of
returning the value of the sum I get a #NAME? error. The odd thing
here is that if I press F2 and then ENTER on the cell, I get the
correct result. The formula doesn't get autocorrected of anything, it
is exactly the same thing that the macro returns. Only that to get the
result I need to F2-ENTER it!

Any idea of what the problem would be? I'd really appreciate it!

Thanks and forgive my bad english!

macro-written correct formula returns #NAME? and #VALUE?
 

VBA is USA centric.

"s.a." wrote:

Unbelievable, but it worked. I forgot to mention it earlier, but
pressing F9 ("Calculate now" or whatever it is called in english)
didn't do anything, and calculations were always set to Automatic.

Why would this happen?

On Apr 9, 1:05 pm, "Norman Jones"
wrote:
Hi S,

Try replacing the Spanish funtion SUMA with the
Englsh equivalent Sum.

Excel will automatically translater the function into the
user''s version language.

---
Regards,
Norman

"s.a." wrote in message

oups.com...

Hello. I'm having troubles writing an excel 2003 macro. I'm using a
line like
Worksheets("ctacte").Range("C" & c) = "=SUMA($C$" & s & ":$C
$" & (c - 1) & ")" <<
to write the formula =SUMA($C$11:$C$12) to a cell in the "ctacte"
worksheet. (SUMA instead of SUM because I'm using a spanish version of
excel).
Problem is, when the macro finishes running, the cell, instead of
returning the value of the sum I get a #NAME? error. The odd thing
here is that if I press F2 and then ENTER on the cell, I get the
correct result. The formula doesn't get autocorrected of anything, it
is exactly the same thing that the macro returns. Only that to get the
result I need to F2-ENTER it!

Any idea of what the problem would be? I'd really appreciate it!

Thanks and forgive my bad english!

--

Dave Peterson