Text Won't Wrap!!

[northbank]

Hi all
I am new to this forum and have only limited experience of excel.
I have a worksheet where i need three columns at fixed widths and in one of these columns i need the text to wrap. I have a macro and have included a wrap text function in it but it doesn't seem to wrap text!! No cells are merged and the row height has not been altered from the default height. I would very much appreciate if one of you could look at the macro(pasted below) and tell me why the text won't wrap. I have looked through forums and found answers to this question, but none of the solutions I have come across seem to work
Many thanks.
Northbank

Please Login or Register  to view this content.

[Andy Pope]

Please add code tags to your post.


Can you post a workbook with some example data that does not wrap.

[northbank]

hi Andy
Sorry about the tags

I have attached the sheet conatining the macro. It's the 'Sort and Save' macro
and the password is 123
Rows 11 and 27 do not wrap the text
Thanks

[Andy Pope]

Please Login or Register  to view this content.

[northbank]

Thanks a million Andy for your help

[Andy Pope]

No problem. Don't forget to edit your first post.

[northbank]

Sorry Andy

I just changed the Font Type to 'Arial Narrow' and the font size from 11 to 10 and row 27 won't wrap now. It leaves out the word 'Ford'
Do you know of any reason why this might happen, or a fix for it?

[northbank]

No problem. Don't forget to edit your first post.

Done. Sorry about that.

[Andy Pope]

It's probably the zoom setting.

At 100% it fits on a single row.

[northbank]

It's probably the zoom setting.

At 100% it fits on a single row.

Do autofit/wrap not take zoom settings into account??

[Andy Pope]

Yes but you are doing things in the wrong order.

You are doing the autofit then changing the font face and size and zoom.

Try this

Please Login or Register  to view this content.

[northbank]

Perfect
Thanks for all your time and patience