Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
remove crlf
I am new to VBA. I need to select a column in the worksheet and remove all
carriage return/line feeds. I am using the following code I got off different posts to this group. What happens is the loop runs forever. What am I doing wrong? Dim aCell As Range Sub Remove_CR_LF() For Each aCell In Selection With Selection .Replace What:=Chr(13) & Chr(10), Replacement:=Chr(32), _ LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False End With Next aCell End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get SQL data to show CRLF instead of question marks? | Excel Discussion (Misc queries) | |||
Making tab do a CRLF when reaching end of a range | Excel Discussion (Misc queries) | |||
Remove last CRLF in text file | Excel Programming | |||
CRLF in .cvs file | Excel Programming | |||
CRLF in text box | Excel Programming |