Re: $$Excel-Macros$$ Change Column Size

2012-09-04 Thread Paul Schreiner
can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Rajan_Verma To: excel-macros@googlegroups.com Sent: Sat, September 1, 2012 1:04:41 AM Subject: RE: $$Excel-Macros$

RE: $$Excel-Macros$$ Change Column Size

2012-09-03 Thread Asa Rossoff
ve time to work on it. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Paul Schreiner Sent: Friday, August 31, 2012 12:18 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Change Column Size >From his description, I think

RE: $$Excel-Macros$$ Change Column Size

2012-08-31 Thread Rajan_Verma
Try to zoom your worksheet Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of mburkett Sent: 31 August 2012 11:41 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Change Column Size I am u

Re: $$Excel-Macros$$ Change Column Size

2012-08-31 Thread Paul Schreiner
.” - John Wesley - From: NOORAIN ANSARI To: excel-macros@googlegroups.com Sent: Fri, August 31, 2012 2:33:54 PM Subject: Re: $$Excel-Macros$$ Change Column Size Without VBa Code you can use.. Alt+O+C+A On Fri, Aug 31, 2012 at 11:44 PM, NOORAIN ANSARI wrote: Dear Mburket, > >

Re: $$Excel-Macros$$ Change Column Size

2012-08-31 Thread Paul Schreiner
the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: mburkett To: excel-macros@googlegroups.com Sent: Fri, August 31, 2012 2:25:31 PM Subject: Re: $$Excel-Macros$$ Change Column Si

Re: $$Excel-Macros$$ Change Column Size

2012-08-31 Thread mburkett
I need it to expand automatically when I select the cell and then return to original width after the cell is not selected. On Friday, August 31, 2012 2:15:08 PM UTC-4, NOORAIN ANSARI wrote: > > Dear Mburket, > > You can use.. > > > Sub column_fit() > Cells.Columns.AutoFit > End Sub > > On Fri, Au

Re: $$Excel-Macros$$ Change Column Size

2012-08-31 Thread Kuldeep Singh
Hi Mburket, Shortcut key: Alt+H+O+I use only Excel 2007, 2010, 2013 Preview. Regards, Kuldeep Singh On Fri, Aug 31, 2012 at 11:48 PM, NOORAIN ANSARI wrote: > Without VBa Code > you can use.. > > Alt+O+C+A > > > On Fri, Aug 31, 2012 at 11:44 PM, NOORAIN ANSARI > wrote: > >> Dear Mburket, >> >>

Re: $$Excel-Macros$$ Change Column Size

2012-08-31 Thread NOORAIN ANSARI
Without VBa Code you can use.. Alt+O+C+A On Fri, Aug 31, 2012 at 11:44 PM, NOORAIN ANSARI wrote: > Dear Mburket, > > You can use.. > > > Sub column_fit() > Cells.Columns.AutoFit > End Sub > > > On Fri, Aug 31, 2012 at 11:41 PM, mburkett wrote: > >> I am using a list with data validation in cells

Re: $$Excel-Macros$$ Change Column Size

2012-08-31 Thread NOORAIN ANSARI
Dear Mburket, You can use.. Sub column_fit() Cells.Columns.AutoFit End Sub On Fri, Aug 31, 2012 at 11:41 PM, mburkett wrote: > I am using a list with data validation in cells c64:c74. The choices are > very long text strings. Does anyone have code that will expand the column > width when I se