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