ExcelBanter - View Single Post - Take a look at my code and tell me what is wrong with this

Tom Ogilvy

Try running this and see if they go away:

Sub ReplaceLittleSquares()
Cells.Replace What:=Chr(10), _
Replacement:="", _
LookAt:=xlPart, _
SearchOrder:=xlByRows, _
MatchCase:=False
Cells.Replace What:=Chr(13), _
Replacement:="", _
LookAt:=xlPart, _
SearchOrder:=xlByRows, _
MatchCase:=False
End Sub

--
Regards,
Tom Ogilvy

"yl358" wrote in
message ...

how do I check if the Range has chr(10) or chr(13)?

--
yl358
------------------------------------------------------------------------
yl358's Profile:
http://www.excelforum.com/member.php...o&userid=35776
View this thread: http://www.excelforum.com/showthread...hreadid=568104