I have cells with Asc(10) characters in them, however when I press the
Delete key or Clear Contents or make the cell = "" the character still
remains in the cell. How can I rid myself of the character using code? I
can get rid of it manually by selecting the cell, clicking in the formula
bar and back spacing.
Any ideas would be appreciated, thanks.

--
Regards,
Rocky McKinley

Hi
maybe something like
range("A1").value=Replace(range("A1").value, chr(10),"")

--
Regards
Frank Kabel
Frankfurt, Germany


Rocky McKinley wrote:
I have cells with Asc(10) characters in them, however when I press
the
Delete key or Clear Contents or make the cell = "" the character
still
remains in the cell. How can I rid myself of the character using
code? I can get rid of it manually by selecting the cell, clicking
in the formula bar and back spacing.
Any ideas would be appreciated, thanks.

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

--
Regards,
Rocky McKinley


"Frank Kabel" wrote in message
...
Hi
maybe something like
range("A1").value=Replace(range("A1").value, chr(10),"")

--
Regards
Frank Kabel
Frankfurt, Germany


Rocky McKinley wrote:
I have cells with Asc(10) characters in them, however when I press
the
Delete key or Clear Contents or make the cell = "" the character
still
remains in the cell. How can I rid myself of the character using
code? I can get rid of it manually by selecting the cell, clicking
in the formula bar and back spacing.
Any ideas would be appreciated, thanks.

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.

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.

Chips Add-In comfirms as my code below did that the Decimal character is
010. It really doesn't matter what character it is as long as I can get rid
of it, that is the main problem. I'm sure someone must have ran into this
one before!

Any help is still appreciated.

--
Regards,
Rocky McKinley


"Rocky McKinley" wrote in message
...
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.

Problem solved thanks for all the help.

--
Regards,
Rocky McKinley


"Rocky McKinley" wrote in message
...
Chips Add-In comfirms as my code below did that the Decimal character is
010. It really doesn't matter what character it is as long as I can get
rid
of it, that is the main problem. I'm sure someone must have ran into this
one before!

Any help is still appreciated.

--
Regards,
Rocky McKinley


"Rocky McKinley" wrote in message
...
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.

ActiveCell.Clearcontents

does exactly that - Asc(10) is not ignored.

You probably didn't apply it to the cell in question.

--
Regards,
Tom Ogilvy


"Rocky McKinley" wrote in message
...
Problem solved thanks for all the help.

--
Regards,
Rocky McKinley


"Rocky McKinley" wrote in message
...
Chips Add-In comfirms as my code below did that the Decimal character is
010. It really doesn't matter what character it is as long as I can get
rid
of it, that is the main problem. I'm sure someone must have ran into
this
one before!

Any help is still appreciated.

--
Regards,
Rocky McKinley


"Rocky McKinley" wrote in message
...
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.