Hi LDF,

See David McRitchie's 'Getting Started With Macros And User Defined
Functions' at:

http://www.mvps.org/dmcritchie/excel/getstarted.htm



---
Regards,
Norman


"LDF" wrote in message
...
I am trying to paste in the code to ensure the merged cells in my
spreadsheet
autofit the text that is written.
I have followed previous queries on the subject, and used the code
provided.
Never having attempted this before, of course it isn't working and I don't
know why.
Any help would be appreciated