PDA

View Full Version : Remove char(13) in a range



daniels012
03-10-2011, 01:49 PM
i need to remove characters from a range.
I got this:
str = Replace(str, vbCrLf, "")

I just don't know how to remove all of them from the Range R2:AI3500

Michael

mancubus
03-10-2011, 02:37 PM
this may help


Sub ReplVbCrlf()

Range("R2:AI3500").Replacel, vbCrLf, ""

End Sub

mancubus
03-10-2011, 03:19 PM
correction:

Range("R2:AI3500").Replace, vbCrLf, ""

Kenneth Hobs
03-10-2011, 04:31 PM
I think you mean remove vblf.
Range("R2:AI3500").Replace, vbLf, ""