This is from Excel help file for row and column size.

Tip To autofit all columns on the worksheet, click the Select All button
and then double-click any boundary between two column headings. Or select all
columns, point to Column on the Format menu, and then click AutoFit Selection.



"straightedge32" wrote:

I was wondering if there was a way to (via macros) enter text into a cell,
and then resize that cell to accomodate the text? Sometimes I enter text
into cells and the text is larger than the default size of a cell, and I
would like to have code that adjusts the size of the column to accomodate the
entire text (so that I don't have to do it manually).

Is there a fast way to do that? Sample code would be greatly appreciated.
Thanks in advance.

-Mike