Dear Bheema, First of all you select a range when you want to apply it... it work after selection...
you select red font area then press it.................................. Hope it will work fine.. On Wed, Sep 7, 2011 at 6:24 PM, Shankar Bheema <shankar.n...@gmail.com>wrote: > I downloaded your file but unable to click on the command button as I > placed my cursor on the command button it is turning into 4 headed arrow and > clicking is not possible. what to do ? > > On Tue, Sep 6, 2011 at 11:02 PM, NOORAIN ANSARI < > noorain.ans...@gmail.com> wrote: > >> Dear Bheema, >> >> Please try it and see attached sheet........ >> >> Sub Autofit() >> If TypeName(Selection) = "Range" Then >> Selection.Columns.Autofit >> End If >> End Sub >> >> >> >> Thanks & regards, >> Noorain Ansari >> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> >> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/> >> On Tue, Sep 6, 2011 at 7:18 PM, Shankar Bheema >> <shankar.n...@gmail.com>wrote: >> >>> sure guruji, pls have a look at my attachment and provide me solution. >>> >>> I marked the cell data with Redcolor. Those are to be adjusted to >>> their width and remaining to their respective widths. Kindly provide >>> solution. >>> >>> On Tue, Sep 6, 2011 at 7:06 PM, NOORAIN ANSARI < >>> noorain.ans...@gmail.com> wrote: >>> >>>> Dear Bheema, >>>> >>>> please share attachement with any rough example.......... >>>> >>>> -- >>>> >>>> On Tue, Sep 6, 2011 at 6:56 PM, Bheema Shankar < >>>> shankar.n...@gmail.com> wrote: >>>> >>>>> Pls. I need a form to adjust to the data widths of different sizes. >>>>> Its a part of the form basing on your solution I have to prepare that >>>>> form of 3 pages. pls provide solution. >>>>> >>>>> -- >>>>> >>>>> ---------------------------------------------------------------------------------- >>>>> Some important links for excel users: >>>>> 1. Follow us on TWITTER for tips tricks and links : >>>>> http://twitter.com/exceldailytip >>>>> 2. Join our LinkedIN group @ >>>>> http://www.linkedin.com/groups?gid=1871310 >>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>>> >>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>> >>>>> <><><><><><><><><><><><><><><><><><><><><><> >>>>> Like our page on facebook , Just follow below link >>>>> http://www.facebook.com/discussexcel >>>>> >>>> >>>> >>>> >>>> -- >>>> >>>> ---------------------------------------------------------------------------------- >>>> Some important links for excel users: >>>> 1. Follow us on TWITTER for tips tricks and links : >>>> http://twitter.com/exceldailytip >>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>> >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>>> <><><><><><><><><><><><><><><><><><><><><><> >>>> Like our page on facebook , Just follow below link >>>> http://www.facebook.com/discussexcel >>>> >>> >>> -- >>> >>> ---------------------------------------------------------------------------------- >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> Like our page on facebook , Just follow below link >>> http://www.facebook.com/discussexcel >>> >> >> >> >> -- >> Thanks & regards, >> Noorain Ansari >> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> >> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/> >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> *http://noorain-ansari.blogspot.com/* <http://noorain-ansari.blogspot.com/> -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel