If cells are merged. the row will not autofit even with wrap text enabled
without using VBA
See google search thread for code by Greg Wilson
Second piece of advice is.............get rid of the merged cells.
They cause no end of problems with copying, pasting, sorting, filtering,
autofitting and a few(many?) others that have slipped my mind at present.
Gord Dibben MS Excel MVP
On Wed, 24 Oct 2007 09:24:00 -0700, Nathan Elphick