Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro for resizing of columns?
Is it possible to use a macro that will resize the columns?
What I mean by this is basically I want a macro that can act as if the divider between column A and column B was double clicked, thus resizing Column A to the size of the largest cell in the column. Is this possible? If so, anyone able to help me out? Any help would be greatly appreciated. Thanks. Matt |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro for resizing of columns?
MatthewTap Wrote: Is it possible to use a macro that will resize the columns? What I mean by this is basically I want a macro that can act as if the divider between column A and column B was double clicked, thus resizing Column A to the size of the largest cell in the column. Is this possible? If so, anyone able to help me out? Any help would be greatly appreciated. Thanks. Matt Hi Matt Try this Sub Macro1() ' ' Macro1 Macro ' Macro recorded 01/12/2005 by ' ' Cells.Select Selection.Columns.AutoFit Range("A1").Select End Sub -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=489889 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro for resizing of columns?
Thanks... that worked out.
Much appreciated. "Paul Sheppard" wrote: MatthewTap Wrote: Is it possible to use a macro that will resize the columns? What I mean by this is basically I want a macro that can act as if the divider between column A and column B was double clicked, thus resizing Column A to the size of the largest cell in the column. Is this possible? If so, anyone able to help me out? Any help would be greatly appreciated. Thanks. Matt Hi Matt Try this Sub Macro1() ' ' Macro1 Macro ' Macro recorded 01/12/2005 by ' ' Cells.Select Selection.Columns.AutoFit Range("A1").Select End Sub -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=489889 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Editing a simple macro | Excel Worksheet Functions | |||
Closing File Error | Excel Discussion (Misc queries) | |||
macro with F9 | Excel Discussion (Misc queries) | |||
Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
Help with macro looping and color query function | Excel Discussion (Misc queries) |