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

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

2011-09-08 Thread Shankar Bheema

is it possible to split the cell column into

On Thu, Sep 8, 2011 at 6:05 PM, dguillett1  wrote:

>   NO can do. Cell width for the entire column must be the same. You can
> merge cells but NO one suggests that so maybe format to WRAP and raise the
> height of the row
>
>
>  *From:* 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 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 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 
>> 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 >> > 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 @
>&

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

2011-09-08 Thread dguillett1

NO can do. Cell width for the entire column must be the same. You can merge 
cells but NO one suggests that so maybe format to WRAP and raise the height of 
the row

From: 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 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  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  
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  
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 
 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://noorain-ansari.blogspot.com/
On Tue, Sep 6, 2011 at 7:18 PM, Shankar Bheema  
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 
 wrote:

Dear Bheema,

please share attachement with any rough example..

-- 

On Tue, Sep 6, 2011 at 6:56 PM, Bheema Shankar 
 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

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.

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 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 
> 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 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://noorain-ansari.blogspot.com/*
  On Tue, Sep 6, 2011 at 7:18 PM, Shankar Bheema >>> > 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/disc

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 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 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://noorain-ansari.blogspot.com/*
>>>  On Tue, Sep 6, 2011 at 7:18 PM, Shankar Bheema 
>>> 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://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.quick

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 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://noorain-ansari.blogspot.com/*
>>  On Tue, Sep 6, 2011 at 7:18 PM, Shankar Bheema 
>> 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://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
>>
>
> --
>
> ---

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
>
> Sub Autofit()
>  If TypeName(Selection) = "Range" Then
> Selection.Columns.Autofit
> End If
>  End Sub
>
>
>
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
> On Tue, Sep 6, 2011 at 7:18 PM, Shankar Bheema 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://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

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-ansari.blogspot.com/* 
On Tue, Sep 6, 2011 at 7:18 PM, Shankar Bheema 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  > wrote:
>
>>   Dear Bheema,
>>
>> please share attachement with any rough example..
>>
>> --
>>
>>On Tue, Sep 6, 2011 at 6:56 PM, Bheema Shankar > > 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://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


test calcul doubt(Updated).xlsm
Description: Binary data

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

2011-09-06 Thread dguillett1

A simple way to do this is to select the column headers(top row marked a,b,c,) 
desired>place you mouse on the line between any 2 and click. Record a macro and 
assign to a shape or button, if desired.

From: Shankar Bheema 
Sent: Tuesday, September 06, 2011 8:48 AM
To: excel-macros@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.


On Tue, Sep 6, 2011 at 7:06 PM, NOORAIN ANSARI  wrote:

  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, Bheema Shankar  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

-- 
--
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

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,
>
> 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, Bheema Shankar 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


test calcul doubt.xls
Description: MS-Excel spreadsheet

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, Bheema Shankar 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

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

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

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

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

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

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

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

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

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

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

10 matches

Site Navigation

Mail list logo

Footer information