You may want to try the Excel discussion group.
They will have more expertise for this question.

Signature
This posting is provided "AS IS" with no warranties, and confers no rights.
Sample code subject to http://www.microsoft.com/info/cpyright.htm
Do not send email to this alias. It is for newsgroup only
> How do I set the rows in my Excel Spreadsheet to autmatically adjust
> according to it's contents?