Re: $$Excel-Macros$$ problem with cell width in a workbook

2011-09-08 Thread Shankar Bheema
m:* Shankar Bheema > *Sent:* Wednesday, September 07, 2011 11:33 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ problem with cell width in a workbook > > good morning Noorain > > I tried with your example sheet. But it is fitting the cell width jus

Re: $$Excel-Macros$$ problem with cell width in a workbook

2011-09-08 Thread dguillett1
$$ problem with cell width in a workbook 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

Re: $$Excel-Macros$$ problem with cell width in a workbook

2011-09-07 Thread Shankar Bheema
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. sup

Re: $$Excel-Macros$$ problem with cell width in a workbook

2011-09-07 Thread Shankar Bheema
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 wrote: > Dear Bheema, > > First of all you select a range when you want to apply it... > it wor

Re: $$Excel-Macros$$ problem with cell width in a workbook

2011-09-07 Thread NOORAIN ANSARI
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 wrote: > I downloaded your file but unable to cli

Re: $$Excel-Macros$$ problem with cell width in a workbook

2011-09-07 Thread Shankar Bheema
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 wrote: > Dear Bheema, > > Please try it and see attached sheet

Re: $$Excel-Macros$$ problem with cell width in a workbook

2011-09-06 Thread NOORAIN ANSARI
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://noorain-ans

Re: $$Excel-Macros$$ problem with cell width in a workbook

2011-09-06 Thread dguillett1
ros@googlegroups.com Subject: Re: $$Excel-Macros$$ problem with cell width in a workbook 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.

Re: $$Excel-Macros$$ problem with cell width in a workbook

2011-09-06 Thread Shankar Bheema
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 wrote: > Dear Bheema, > > pleas

Re: $$Excel-Macros$$ problem with cell width in a workbook

2011-09-06 Thread NOORAIN ANSARI
Dear Bheema, please share attachement with any rough example.. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Tue, Sep 6, 2011 at 6:56 PM, Bh

$$Excel-Macros$$ problem with cell width in a workbook

2011-09-06 Thread Bheema Shankar
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