PDA

View Full Version : Line break adding a space



JoshSnitzel
02-01-2016, 09:52 PM
Hi all,

I am replacing certain strings with other strings but I've noticed when I include a line break, it is adding a space to the front of the new line..
What's the best way to stop this?

Cheers

JoshSnitzel
02-10-2016, 05:30 PM
For anyone else, I solved this by using Chr(13) instead of vbCr.

gmaxey
02-11-2016, 06:12 AM
A line break is Chr(11)

JoshSnitzel
02-11-2016, 02:42 PM
A line break is Chr(11)
oops, yep that's the one!