Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I would like to add somehting to this clean up macro:
Sub Cleanup() With ActiveWorkbook .Names("Database").Delete Application.DisplayAlerts = False .SaveAs .FullName, xlWorkbookNormal Application.DisplayAlerts = True End With End Sub the above macro clears out a named range and it does a save as to the current version of excel. is it possible to added to the tail end of this routine the task of shrinking the column width down to the widest value in the column - for some reason the columns come though overly large "wide" |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Expand and Shrink Rows and columns to hide information. | Excel Discussion (Misc queries) | |||
Can I expand & shrink columns? | Excel Discussion (Misc queries) | |||
Can rows/columns Automaticly Grow/Shrink? | Excel Discussion (Misc queries) | |||
Shrink and expand a number of columns/rows | Excel Worksheet Functions |