Row Height Adjustment on data Imported into excel

[Lisa]

Hi

when I export a file from our database into excel - the format function of
automatically fit row to data doesn't work - nor does the the use of the
mouse to click on the line between the rows - I regularly format large
imported data files and it's very frustrating!!

Any suggestions??

 

[Gord Dibben]

Do you wrap text set on the cells?

Do you have any "merged cells".

These will prevent the row expansion and must be dealt with through the use
of event code behind the worksheet.

For worksheet event code...............

See google search thread for code by Greg Wilson. Watch out for word wrap
in the URL which all one line.

http://groups.google.com/group/micr...60cbeb27874?lnk=st&q=&rnum=4#ca1c160cbeb27874


Gord Dibben MS Excel MVP