title: Getting Right Cell Name of current Cell VBA excel
body: <p>I have current cell name like <code>B7</code> i want to get cell name of the cell right to current cell for example in this case the result will be <code>C7</code>. How can I achieve this
  This is what I have tired but its not working</p>
  
  <pre><code>CellName = "B7"
  ValueCellName = Right(Range(CellName)).name
  </code></pre>