automatic cell resize
 

In my excel spreadsheet, i type a lot of information into individual
cells. Most of the time this information carys on to anonther line and
i have to resize the cell by hand if i want the information to print.

How can i create a macro to resize these cells automatically? Please
help.


--
xman123
------------------------------------------------------------------------
xman123's Profile: http://www.excelforum.com/member.php...o&userid=35532
View this thread: http://www.excelforum.com/showthread...hreadid=560188

automatic cell resize
 

Hi

Try this code

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
ActiveSheet.UsedRange.Select
Selection.Columns.AutoFit
Application.EnableEvents = False
Range("a1").Select
Application.EnableEvents = True
End Sub


--
jetted
------------------------------------------------------------------------
jetted's Profile: http://www.excelforum.com/member.php...o&userid=17532
View this thread: http://www.excelforum.com/showthread...hreadid=560188