Cannot create text string

[jcprata]

Hi,

I am trying to create the following text string that matches this formula:

Please Login or Register  to view this content.

The text string that i want, to be equals to the formula is the following:

Please Login or Register  to view this content.

When i run my problem i have an error in this text string, and the error is "application-defined or object-defined error".

Best Regards,
JP.

[DonkeyOte]

VBA in heavily Americanised - ie when writing formulae from VBA to cells always use US based syntax regardless of your own locale.

In this particular instance you should use a comma delimiter as opposed to the semi colon (as you use in native XL given your locale)

ie

=SUMIF(A22:A60;"<>zEz";R22:R60)

would be entered from VBA as

=SUMIF(A22:A60,"<>zEz",R22:R60)

regardless of client locale.... so in short change ; to , and you should be ok.

Note: once "written" to native XL the delimiters will be translated automatically - ie the commas will have become semi-colons.

[jcprata]

Hi,

I have tried that solution but didnt worked.
I think the problem is with the zEz string, in that criteria i want to compare the text string "zEz". (note that zEz is not an alias of a range/cells)

Best Regards,
JP.

[DonkeyOte]

JP, I did not notice previously but you have a space in your string after the last reference to column R (prior to insertion of LastRow variable) and this is not valid syntax - if you correct for that your formula should work without issue (semi colon point holds).

EDIT: I should add that if you use .FormulaLocal property as opposed to standard .Formula you can enter with locale specific delimiters

[jcprata]

Thank you it worked fine, i hate this type type of errors, next time i ill be more atention
I am using Formula.

Best Regards,
JP.