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