title: VBA Cells.Replace()
body: <p><strong>SETUP</strong></p>
  
  <p>I'm using VBA in Excel 2012</p>
  
  <p><strong>QUESTION</strong></p>
  
  <p>I need to search through a sheet and replace any "#"s. Only in the first column. The Second Cells.Replace does not work. I assume it is because "# # #" doesn't like that type of string.</p>
  
  <p><strong>CURRENT CODE</strong></p>
  
  <pre><code>    'Find and replace "#" with ""
      Cells.Replace What:="###", Replacement:="", LookAt:=xlPart, SearchOrder:= _
      xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
  
      Cells.Replace What:="# # #", Replacement:="", LookAt:=xlPart, SearchOrder:= _
      xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
  </code></pre>
  
  <p>Any Thing would.</p>