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??

 

[Simon Lloyd]

You could use VBA to autofit it but i suspect you are importing
trailing/leading spaces and maybe carriage returns in cells, is this the
case?

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??

--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)

 

[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