good morning Noorain I tried with your example sheet. But it is fitting the cell width just like the Format-->Autofit option in the excel. But what I need is,
the particular cells containing the red font has to be fit to their text width and the following column width may left as they are. suppose d10 is having 2 characters d15 is having 34 characters both should fit to their textwidths without disturbing the remaining cell widths in the same column. On Wed, Sep 7, 2011 at 6:40 PM, Shankar Bheema <shankar.n...@gmail.com>wrote: > I am not getting even after selection as you said. I noticed non of the > control is allowing to work on the sheet what would be the prblem with my > excel ? > > On Wed, Sep 7, 2011 at 6:31 PM, NOORAIN ANSARI > <noorain.ans...@gmail.com>wrote: > >> 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 >> > > -- ---------------------------------------------------------------------------------- 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
