title: Run Time and Compatibility Errors using Variable Type "Double"
body: <p>I have a strange issue using <code>Double</code> type variables in my VBA Macros.</p>
  
  <p><strong>The Macro works fine when I test it on some systems, but causes a runtime error '1004' when tested on another system with different language settings.
  Both systems use Office 2013.</strong></p>
  
  <p>I have a ScrollBar in a form, with values ranging from -50 to + 50. 
  Basically an indicator to increase/decrease the value of a range by -/+ 50% 
  The Macro is something simple like follows:</p>
  
  <hr>
  
  <pre><code>Dim multiplier As Double
  
  multiplier = CLng(Me.DPScroll.Value) / 100 + 1
  ThisWorkbook.ActiveSheet.Range("AB11:AB" &amp; LR).Formula = "=H11*" &amp; multiplier
  </code></pre>
  
  <hr>
  
  <p>When the <code>DPScroll.Value = 0</code> (Multiplier = 1), the form runs file without any errors, but if it has a positive or negative value, it returns </p>
  
  <blockquote>
    <p>Run-time Error 1004 : Application Defined/Object Defined Error</p>
  </blockquote>
  
  <p>(On my system, both work fine)</p>
  
  <p>So, I'm guessing the Multiplier is unable to take values in Decimal Points (Eg. 1.07 to increase by 7%)</p>
  
  <p>(Less important issue)
  It also causes a strange formatting error on another sheet. 
  I'm calculating the average of a few rows in a list box and pasting the value to a range. On some systems, the format is retained, but on others it changes and gets multiplied by millions and a Large number is displayed (like 10^E6 times)</p>
  
  <p>Since this is restricted to some systems - are there any regional/language compatablity issues with suing "Double" variable type.</p>