title: powershell Call method with optional arguments
body: <p>I have an excel vba code that finds a particular cell in a sheet. It uses the <code>Find</code> method form the excel libraries. Here is the code</p>
  
  <pre><code>objRange.Find(What:="*", SearchDirection:=xlPrevious, SearchOrder:=xlByRows)
  </code></pre>
  
  <p>I need to do the same thing in powershell. But this method has a total of 9 arguments. How to ignore the other optional arguments in powershell. Something like this?</p>
  
  <pre><code>$range.Find("*", "", "", "", $xlByRows, $xlPrevious, "", "", "")
  </code></pre>
  
  <p><a href="http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.range.find%28v=office.14%29.aspx" rel="noreferrer">Here</a> is the documentation of <code>Range.Find</code> Method</p>