Hi, the following code displays as a single line
Obviously cells B8 and B9 are separate lines. How can I make the codes output display as such?
Code:
If Range("B8").Value = "" Then
Line1 = "Blank."
Else
Line1 = Range("B8").Value & " " & Range("C8").Value
End If
If Range("B9").Value = "" Then
Line2 = "Blank."
Else
Line2 = Range("B9").Value & " " & Range("C9").Value
End If
Obviously cells B8 and B9 are separate lines. How can I make the codes output display as such?