title: Excel vba replace comma with
body: <p>I want to use this vba code in my sheet to replace any commas in column D with a full stop:</p>
  
  <pre><code>ActiveSheet.Columns("D").Replace _
  What:=",", Replacement:=".", _
  SearchOrder:=xlByColumns, MatchCase:=True
  </code></pre>
  
  <p>I had it working I'm sure for a minute but then it didn't! Any ideas???</p>