Hi,

I am in the UK and I write reports for colleagues in other offices around the world. I wrote this code with a simple do while loop whic adds a calculation to the end of each row where the first cell is not blank. The calculation is:

PHP Code: 
ActiveCell.Offset(0, 10) * ActiveCell.Offset(0, 9) 
Simple, right?... no! With my English regional settings it would show the calculation as this:

PHP Code: 
.0764000000000000 * 1,000 
and that works fine for me and my US colleagues but not for my friends in France, because theirs would be
PHP Code: 
,0764000000000000 * 1.000 
even if not for the , at the start of the first number, it would multiply by 1 instead of 1,000 so would give completely the wrong answer!

Obviously I can't expect all of my French colleagues to change their regional settings just so that they can run this report, so how can I fix this issue?

Thanks,

Soph