title: VBA Replace in Excel "statement invalid outside type block"
body: <p>Having a compile error, "Statement invalid outside Type block"</p>
  
  <p>I'm trying to search column C for the string "Steel Structural" and if it is present, then replace it with "Structural Steel"</p>
  
  <p>I need this to be a button that I press so there is no loop in the cell formatting, or else I would just use a basic excel function to reverse the words</p>
  
  <p>Here is my code:</p>
  
  <pre><code>Private Sub CommandButton1_Click()
  Range("C:C").Select
  If MT = "Steel Structural" Then
  Replace("Steel Structural", "Steel Structural", "Structural Steel") As String
  End Sub
  </code></pre>
  
  <p>What am I doing wrong?</p>