title: Excel - VBA : Make the "replace" function more specific
body: <p>I am currently encountering a problem which doesn't seem that hard to fix but, yet, I can't find a clean way of doing it on my own. </p>
  
  <p>I am using the "Replace" function to change some expressions in a sentence typed by an user. For example, if the user types "va", I want it to be turned into "V. A." instead so it will match more easily with my database for further operations.</p>
  
  <p><strong>Here is my simple code to do it</strong> :  </p>
  
  <pre><code>sMain.Range("J3").Replace "VA", "V. A."
  </code></pre>
  
  <p>It works well.<br>
  Problem is, <strong>it's not only spotting "VA" as an individual expression, but also as a part of words</strong>. </p>
  
  <p>So if my user types "Vatican", it's gonna turn it into : "V. A.tican"... which of course I don't want.  </p>
  
  <p>Do you know how to easily specify my code to make it ONLY consider replacing the <strong>whole words</strong> matching the expression? (I have dozens of lines of these replacement so ideally, it would be better to act directly on the "replace" functions - if possible).</p>
  
  <p>Thanks in advance !</p>