VBA code to wrap text?

I didn't find a search on this forum. Hope I'm not asking something that has already been addressed here.

Is there a way using vba to set some or all of the columns to automatically wrap text, similar to the Excel functionality? I was shocked at Microsoft's suggestion to do it one row at a time. There are hundreds of tasks already in my project.

While I'm asking the question, is there also a way to word wrap the memo field, or does it word wrap when printing already?

Thank you.

glr

Yes, you can do it but remember that the Project only wraps fields that contain a space in the text string. Also it will work with row height and will not call it "text wrap". So, however you can do it using VBA I don’t think it is really worth to write code just for that. As far as your second query is concerned do you mean ‘Notes field’ for the term ‘memo’? If yes, then the best way to get the Notes field to print fully is to use File/Page Setup/View tab and set the option to print notes.

Try using
Worksheet.Cells.WrapText =true
to wrap all the cells.

(Hope this works!!!)

Regards,
Renu