title: VBA Compile error
body: <p>I have very little experience with VBA and the last time I used it was years ago.
  Heres my VBA:</p>
  
  <pre><code>Function MacIDGen(total, current)
  If total - current = 0 Then
      current -1
  Else
      current 1
  End If
      Macro1 (current)
  End Function
  
  Sub Macro1(cur)
      Sheets("Donations").Cells(I2).Value = cur &amp; "Test"
  End Sub
  </code></pre>
  
  <p>It's its own module, no other code in with it at all.</p>
  
  <p>So I have a cell which is calling MacIDGen(). It's passing MacID two other cell values. The error comes whenever it's executed, "Compile Error: Expected Sub, Function, or Property" and highlights the functions method signature.</p>
  
  <p>I have no idea why its kicking this up here, I'm guessing its because I've either missed a major step or something about how you can't have a function in that context or some other such issue. </p>
  
  <p>EDIT
  As a little extra info, I'm creating these spreadsheets in Excel to serve as random data generation sheets to be imported into a drupal site. I've encountered a problem that cannot be resolved without the use of loops (I also can't hard code the number of iterations either), which formulas don't do.</p>