autofit text that is pulling data from another tab
 

I have a quote spreadsheet that uses a macro on 2 tabs:

tab one is to enter your part number and VLOOKUP the part to get cost and
then set you margin

tab two shows data from tab one however excludes all cost & margin information

My problem is that even though on though the product description field on
both tabs is formatted (Format Cells Alignment tab Wrap text), my row
cannot autofit the height on either tab to fill in all the information.

Is there a way I can do this so that my font doesn't "shrink to fit" making
it impossible to read the description? My product descriptions can vary from
5 to 30 words and are pulled from a vendor price list.