We have VBA Macro in which we are using constants
min = 0.5
max = 0.999

If the locale is US[English] the macro code work fine with these constants

If the code is used in Europe which has a differnt locale
which represent "decimal symbol = , ". So in the macro code
the decimal is getting dropped.

min = 5
max = 999

Is there a way to fix this problem without much modifying the code as these constant are scattered accorss the code?

Thanks in advance.