Perhaps this isn't your problem, but just to be su
Assuming you are using Jim Rech's code, you have to run the code for it to
do anything. Just putting it in a module does not cause it to autofit
merged cells.

Also, this line
If .Rows.Count = 1 And .WrapText = True Then
tells you that it only works for single row, multiple column merged cells
(with WrapText set to true)

--
regards,
Tom Ogilvy



"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