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
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