<div>
Select the cell and run this macro<br />
<br />

<pre><code id="code-20-38727129-1">Sub testlastnum()
If Right(Selection, 1) &lt;= &quot;9&quot; And Right(Selection, 1) &gt;= &quot;0&quot; Then MsgBox &quot;yes&quot; Else MsgBox &quot;no&quot;
End Sub</code></pre>
</div>


Select the cell and run this macro



Sub testlastnum()
If Right(Selection, 1) <= "9" And Right(Selection, 1) >= "0" Then MsgBox "yes" Else MsgBox "no"
End Sub

<div>
Hi,<br />
<br />
You could also use<br />
<br />
result = Selection Like &quot;*#&quot;<br />
<br />
Regards
</div>


Hi,

You could also use

result = Selection Like "*#"

Regards

<div>
Thank you so much for the quick and very helpful answer.<br />
<br />
The other response is also most appreciated.<br />
<br />
Thanks<br />
Alison
</div>


Thank you so much for the quick and very helpful answer.

The other response is also most appreciated.

Thanks
Alison

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I would be very grateful if you could suggest how I can use VBA to ascertain if the last character in a cell is a number (0 through to 9). <br />
<br />
Many thanks in advance<br />
Alison
</div>
</div>


Hi,

I would be very grateful if you could suggest how I can use VBA to ascertain if the last character in a cell is a number (0 through to 9). 

Many thanks in advance
Alison

Excel VBA - how to test if last character in a cell is a number

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.