Dear Friends,
Does anyone have a macro to reduce column size all together?
Best Regards,
Amit
Disclaimer: This message and its attachments contain confidential information
and may also contain legally privileged information. This message is intended
solely
You mean column width?
Sam
On Sun, Jun 17, 2012 at 2:38 PM, Amit Desai (MERU)
amit.de...@merucabs.comwrote:
Dear Friends,
** **
Does anyone have a macro to reduce column size all together?
** **
Best Regards,
Amit
** **
--
Dear Amit,
May be I'm not sure whether you are familiar with this Or this is what you
are looking for i.e for making all columns adjust according to the Raw Data
in a sheet you do this Ctrl + A to select entire sheet and after this
Alt + O + C + A.
Hope this helps.
On Sun, Jun 17, 2012 at
use this macro
Sub gg()
Selection.ColumnWidth = 5
End Sub
you can change column width as per your need
On 6/17/12, Ahmed Honest ahmedhon...@gmail.com wrote:
Dear Amit,
May be I'm not sure whether you are familiar with this Or this is what you
are looking for i.e for making all columns
Thanks a lot for solutions..
Best Regards,
Amit
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of ankur
Sent: 17 June 2012 16:10
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macro for column size reduction
use