title: Text Function for multiple cells
body: <p>I wanted to know if there is an alternative method (than loops) for using a text function on multiple cells.</p>
  
  <p>For example, the below code work correctly for lookups</p>
  
  <pre><code>Range("c2:c6").Value = Application.WorksheetFunction.VLookup(Range("a2:a6"), Range("a2:b6"), 2, 0)
  </code></pre>
  
  <p>However I get an error with the below for text functions</p>
  
  <pre><code>Range("c2:c6").Value = Application.WorksheetFunction.Text(Range("A2:A6"), "000000")
  </code></pre>