title: Specifing a range as a string for countifs excel vba
body: <p>I am trying to provide variable input for countifs, and stuck up with how to do the below.
  Let me know if there is any possible way to do it.</p>
  
  <pre><code> dumi = ".Range(.Cells(2, Submit_date), .Cells(lastrow, Submit_date))"
   i = Application.WorksheetFunction.CountIfs(dumi, "&gt;=" &amp; date1, _
   dumi, "&lt;=" &amp; date2)
  </code></pre>
  
  <p>Also i tried,</p>
  
  <pre><code> dumi = .Range(.Cells(2, Submit_date), .Cells(lastrow, Submit_date))
        i = Application.WorksheetFunction.CountIfs(dumi, "&gt;=" &amp; date1, _
        .Range(.Cells(2, Submit_date), .Cells(lastrow, Submit_date)), "&lt;=" &amp; date2
  </code></pre>
  
  <p>But none works.. Help me out</p>