VBA written in English but use in multiple countries

[hcabs99]

HI.

I have some vba code which is used by users in Romania and Bulgaria and in the UK

Appears i have an issue with the code when i use value

eg:

ActiveCell.FormulaR1C1 = "=IF(RC[-1]>0,VALUE(RC[-1]),"""")"

I assume this to be because the formula in these countries is in the local language so Excel does not recognise the word - Value

Any ssuggestions how i can get round this problem please?

Cheers

 

[Norie]

What's the 'issue'? Are you getting errors?

 

[hcabs99]

What's the 'issue'? Are you getting errors?

I get a #Value error as the cell update does not work as the = value command is not recognised in Romania .