Yes that all worked brilliantly in terms of Error Handling, any chanc
you could explain this a little more? Not sure I understand :S

Given that you have a lot of related info, I would probably make a clas
out
of this to handle its own reading from XL WS, validation and writin
to
Word.
e.g. <cLOAProjectReport
Public Property Let SourceWS (vData as Excel.Worksheet)

Public Property Let WordTemplateName (vData as String)

Public Function Generate (Optional LogResults As Boolean=True) A
String
'Return the address of the first cell missing dat

--
ChrisMattoc
-----------------------------------------------------------------------
ChrisMattock's Profile: http://www.excelforum.com/member.php...fo&userid=3391
View this thread: http://www.excelforum.com/showthread.php?threadid=55793