You can monitor changes with a sheet_change event and use the autofit method
to adjust the column size for the column.
--
http://HelpExcel.com




"melanasue" wrote:

I am putting together a template and I need my cells to auto-adjust to the
amount of text being put into them. I will not be the person putting the data
in or pulling the data together, so it is important that the cells autoformat
and adjust to the amount of text being placed in the cell.