Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Adjust the size of cells automatically
I need to adjust the size of cells automatically. I am copying information
from one sheet to another automatically and depending on what amount of information is copied the size of these cells has to adjust automatically or at least increase to accomodate all text. Is there any way to do this? Thanks |
#2
|
|||
|
|||
Dajana,
This worked for me: Paste this code into ThisWorkbook code module in the VBA Editor Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) Target.Columns.AutoFit End Sub Ken Johnson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The Excel cells are not automatically calc. existing formula. | Excel Worksheet Functions | |||
automatically adjust row height in excel 2000 | Excel Discussion (Misc queries) | |||
Can I combine the text from multiple cells automatically | Excel Worksheet Functions | |||
copying content of cell automatically to multiple cells | Excel Worksheet Functions | |||
automatically fit an image into merged cells | Excel Discussion (Misc queries) |