title: excel vba select second to last character in a cell
body: <p>I thought this would be simple but can't find the solution anywhere! I am writing a macro to insert a red tick (or down arrow) after the existing text in a cell.</p>
  <pre><code> ActiveCell.FormulaR1C1 = ActiveCell &amp; &quot; P &quot;
  </code></pre>
  <p>The P needs to be formatted bold, red and Wingdings 2.  It needs a space after it in case text is added at the end in the future.</p>
  <p>No problem if it is before the text:</p>
  <pre><code>With ActiveCell.Characters(Start:=2, length:=1).Font
  </code></pre>
  <p>How can I select it when it is the second to last character in the cell?</p>
  <p>(Or is there any other way to achieve this?)</p>