Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert date | Excel Worksheet Functions | |||
automatic cell resize | Excel Discussion (Misc queries) | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
automatic offset cell location when there is a value in a selected cell. | Excel Worksheet Functions |