title: Substitute Function in Excel VBA for cell range
body: <p>I have to replace one character with another in Excel file.</p>
  
  <p>I have used following <code>Replace</code> function, but due to exceeds of 1024 character limit in some cells, it stops there.</p>
  
  <pre><code>Sub Replace()
  
      With Sheets("Sheet1").Range("A1:A629")   
  
        .Cells.Replace ",", ";", xlPart, xlByRows, False
  
      End With
  
  End Sub 
  </code></pre>
  
  <p>I got to know <code>Substitute</code> function would do</p>
  
  <pre><code>Cells(1, 2) = "=SUBSTITUTE(A1,"","","";"")"
  </code></pre>
  
  <p>But how do I use that for cell range?</p>