Where is your macro?

__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/

Select the column B of the used range, right click the selection and select Format Cells Menu, in Alingment enable "Wrap text" option, do this before copy to word.
To insert this procedure into your macro you can do something like this:
oRange.columns(2).wraptext=true
Backup before test.

__________________
Backup your original file before doing any modification.