I am not sure when you say, You set the height to all 13 rows as
autofit. Did you manually set the height to some value so that it
looks autofit or you went to formatrowAutofit. If you did do the
second option, then it should work and it should be always autofit and
make you all the rows visible with any and all values typed inside the
cell. May be you can also check the format of all cells to see if the
checkbox "Wrap Text" is checked...

I hope this helps...

Selva V Pasupathy
For more on VBA, Excel, & other Programming
Please visit http://socko.wordpress.com