Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MAX returns correct column, but row -1? | Excel Worksheet Functions | |||
Excel to run Word macro & Word returns value to be written in spreadsheet | Excel Programming | |||
Address block carriage returns not correct | Excel Worksheet Functions | |||
Sum formula in macro returns zero | Excel Programming | |||
Excel returns @name? error when using a custom written function in | Excel Programming |