The actual Excel imported data doesn't need to be altered, just a short piece of text before each of the tables to provide an explanation of what each table contains. To make things easier the text will always be fairly constant, dependent only on which table data is imported into the document.

Hence my thinking of something along the lines of using the Case method (eventually).

If Markers or Markers1 is used, then the text will be "These are the markers shown" & vbCr & vbCr
If Person or Person1 is used, then the text will be "These are the records shown for the past eighteen months" & vbCr & vbCr

If Markers or Markers1 is not used, then the text will be "No records held" & vbCr & vbCr
If Person or Person1 is not used, then the text will be "Currently no records can be found" & vbCr & vbCr

This is why my previous idea of importing into a TextBox is actually not required. My only reason originally was only to add the lines of text as mentioned above. No other reason.


Sorry, I still cannot get your code to work. I must be doing something wrong somehow but I just cannot fathom how.

I'm still hoping that my code in post #38 can be "tweaked" to make it work.