title: VBA does not accept my method calling and gives Compile error: Syntax error
body: <pre><code>Public Sub SavePendleValues(ByVal row1 As Integer, ByVal row2 As Integer)
  </code></pre>
  
  <p>Calling it  </p>
  
  <pre><code>For sheetrow = 2 To 15 ' number of rows to scan
      SavePendleValues (sheetrow, sheetrow)
  Next sheetrow
  </code></pre>
  
  <p>Getting error : <code>Compile error: Syntax error</code></p>
  
  <p>When I uncomment the line: <code>SavePendleValues (sheetrow, sheetrow)</code></p>
  
  <p>Everything works.</p>