I used the code below to check the cell in question and the message box came
up with 10 as the only answer.

Sub CheckCellValue()
Dim a as Integer
For a = 1 To 255
If Chr(a) = Range("AE16").Text Then MsgBox a
Next a
End Sub

I'll check out Chip's page as you suggested, thanks.
--
Regards,
Rocky McKinley


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Rocky

How do you know the character is asc(10)?

Maybe asc(13) or some other.

Check out Chip Pearson's Cellview add-in to see what you have in the
cell(s)

http://www.cpearson.com/excel/CellView.htm

Gord Dibben Excel MVP

On Fri, 11 Jun 2004 16:04:32 -0700, "Rocky McKinley"
wrote:

Unfortunatley that didn't work, thanks for the try though.