I am trying to pull together three different locations into one cell. The first location will always be entered, but its not a given that the second or third will be entered (the second may be entered, but not the third; or the third may be entered but not the second) - see the attached file.
I am trying to use If Statements to determine if there is something in the cell, and if so include it into a single cell. Here is the code I am using (although, its not working):
Range("D1") = Range("B1") & _
If Not (Range("B2")) = "" Then
Chr(10) & Range ("B2")
End If & _
If Not (Range("B3")) = "" Then
Chr(10) & Range ("B3")
End If
Does this make sense? I'm sure it's easy to do . . . but I'm still working my way through VBA.
Thanks!
Bookmarks