Auto Resizing cells

[progressive7]

i have a sheet with which all the cells are formated to waord wrap. however when a user enters a load of text it does not do the word wrapping untill the cell is manually resized. is there any way to combat this?

 

[BlackburnKL]

You can use

Columns("A:A&quot.EntireColumn.AutoFit

where "A" is the desired column to autofit the column to the widest entry. This may not be what you need, however, because you are using word wrap for long entries. If you want to expand acolumn to a certain with, you can use

Columns("A:A&quot.ColumnWidth = 20

replacing the 20 with your desired column width.

Good luck! BlackburnKL

 

[plantj]

I think its is Row.autofit that is required. Autowidth of columns doesn't help much with word wrapped cells. Excel usually tries to autofit when you edit wrapped text anyway but it doesn't always succeed for reasons unknown to me.

 

[progressive7]

sorry to appear ingnoragrant but where to i place this code?

 

[BlackburnKL]

In a VBA macro. It could run off of an event. BlackburnKL