View Single Post
 
Old 10-10-2017, 01:47 PM
slaycock slaycock is offline Windows 7 64bit Office 2013
Expert
 
Join Date: Sep 2013
Posts: 255
slaycock is on a distinguished road
Default

Glad it is sort of working (What went wrong initially - do you know?)

For the 66 books this shouldn't be a problem

In VBA the '_' at the end of a line is a line continuation character so you should be able to create the initial string by extending as follows

Code:
Const LIST_OF_AUTHORITIES    As String = "John, Matthew,Mark , Revelation," _
                                                                   & "Genesis, Exodus , Judges, " _
                                                                   & " Book1, Book2, Book3, Book4, book5, book6,  book7 " _
                                                                   & "Book8, Book9, Book10, Book 11"  etc
The individual lines can be longer but I try to keep within about 80-100 characters. Please make sure that each set of names has a finishing ',' except for the last set.

If this doesn't work for you then just write a paragraph seperated list on an empty page at the end of your document and I write a sub to collect the reference names from there.

The occasional . or ) embedded in your hyperlinks just means I've missed an edge case. I'll add some code to check for that.
Reply With Quote