trying to automatic fit large amount of text in cell

[rp2chil]

Hi, I've researched the board and I can't find the correct answer.

We have several users updating a spreadsheet. In one of the cells users
have to enter text that could be up to 1000 characters. Is there a way that
when a user either pastes data or enter text that the columns or rows expand
to automatically fit the text.

Thanks so much

Using Excel 2003 and not a programmer . Tnx much.

 

[HKaplan]

Hi, I've researched the board and I can't find the correct answer.

We have several users updating a spreadsheet.  In one of the cells users
have to enter text that could be up to 1000 characters.  Is there a way that
when a user either pastes data or enter text that the columns or rows expand
to automatically fit the text.

Thanks so much

Using Excel 2003 and not a programmer .  Tnx much.

Right click the sheet tab, then select View Code.
In the right pane, select Worksheet in the first drop down and Change
in the second.
Paste this code.

Private Sub Worksheet_Change(ByVal Target As Range)

Cells.Select
Cells.EntireColumn.AutoFit
Target.Select

End Sub

 

[rp2chil]

awesome, thanks So much...