Macro for resizing of columns?

[MatthewTap]

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

 

[Paul Sheppard]

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, thu
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 Su

 

[MatthewTap]

Thanks... that worked out.

Much appreciated.

Hi Matt

Try this >

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 01/12/2005 by
'

'
Cells.Select
Selection.Columns.AutoFit
Range("A1").Select
End Sub