Is there any way I can move to the next line within a bookmark in vba
The code I have is as follows but I need the Address to be on new lines.
Code:
If ComboBox1.Value <> "Building Control Letter" Then
Set rngBookmark = .Bookmarks("Address").Range
.Bookmarks("Address").Delete
rngBookmark.Text = "Address #1" & "Address #2" & "Address #3" & "Address #4" & "Address #5" & "Address #6"
.Bookmarks.Add Name:="Address", Range:=rngBookmark
End If