Thanks but unfortunately that doesn't work either, it would if it were text,
but because it's coming from a VLOOKUP, for some reason it doesn't work.

I wonder if there's something I've overlooked?

M


"Jacob Skaria" wrote in message
...
Cells.SpecialCells(xlCellTypeFormulas).Rows.AutoFi t

If this post helps click Yes
---------------
Jacob Skaria


"Michelle" wrote:

No, Thanks, but WrapText is already on for these cells, it's just that
the
row height is not adjusting automatically.

M


"Jacob Skaria" wrote in message
...
Sub Macro()
Cells.SpecialCells(xlCellTypeFormulas).WrapText = True
End Sub

If this post helps click Yes
---------------
Jacob Skaria


"Michelle" wrote:

I have some VLOOKUPs which sometimes return 50 or 60 characters
(they're
in
merged cells). I want the text to wrap, and the cell to enlarge to fit
the
text - Just like it does whan you type it in, but somehow, because it
is
being returned from a formula it just displays the bottom line of the
wrapped text, and doesn't resize the row.

Anyone know how I cam make it fit?

I'm happy to use a VBA solution if there's no built in way to make it
happen
automatically.

Thanks

M