title: Excel VBA module subroutine not being picked up with parameter
body: <p>In a new excel spreadsheet, I have inserted a new module and entered a public sub.  When trying to test, the sub does not appear in the macro list unless I remove the parameter.</p>
  
  <p>This behaviour is bizarre and I cannot find any reference to it as an issue, everything I have read declares that subroutines (or functions, tried that too) can have parameters.</p>
  
  <pre><code>Public Sub RetrieveSIR()  &lt;-- Can be found
  Public Sub RetrieveSIR( SIRNumber as Integer)  &lt;-- Cannot be found
  </code></pre>
  
  <p>It is driving me around the bend trying to work this out.  If anyone can help, it would be much appreciated.</p>