Trouble with .Formula

[pmguerra]

Hi!

I'm getting a little trouble inserting a simple formula through VBA

CODE:

Please Login or Register  to view this content.

The formula is in portuguese but the basis is: if both cells H2 and G2 are numbers, then 1111, else 2222.

I copied the formula straight from the sheet and pasted it in the VBA code as a string

When I run it I get an "application-defined or object-defined error"

Am I using the .Formula propertyincorrectly? How can I solve this?

Thanks in advance!

[Bob Phillips]

Try this (trust me!)

Please Login or Register  to view this content.

[pmguerra]

Indeed I trust you...

I had already translated the formula to plain english and got the same error. Tried it again and still no change...

[royUK]

Replace the semi colons with commas

Please Login or Register  to view this content.

[pmguerra]

Thanks!

That worked, royUK.

Still I find it pretty "annoying" that the formula doesn't work in portuguese...

Thank you!

[Bob Phillips]

Thanks!

That worked, royUK.

Still I find it pretty "annoying" that the formula doesn't work in portuguese...

Thank you!

That is because VBA only understands English. The language extensions are in Excel, not VBA, it is just a layer and eveyrthing gets semi-compiled into a common denominator.

[pmguerra]

Yes, I can understand that.

Still, I tried the "portuguese version" of the formula, by substituting the the ";" for "," and I didn't the run-time error I got before. Instead, in the worksheet, I got a #NAME error.

When I performed a simple edit on the formula (F2 + Enter), it recognized it and it returned the value correctly...

Try and explain that...

Thank you for the help!!!

[Bob Phillips]

Yes, I can understand that.

Still, I tried the "portuguese version" of the formula, by substituting the the ";" for "," and I didn't the run-time error I got before. Instead, in the worksheet, I got a #NAME error.

When I performed a simple edit on the formula (F2 + Enter), it recognized it and it returned the value correctly...

Try and explain that...

Thank you for the help!!!

I have never seen that. I knew your original problem, that is how I knew how to solve it, but it works thereon for me.