PC Review


Reply
Thread Tools Rate Thread

Display col width in a cell

 
 
Kieranz
Guest
Posts: n/a
 
      7th Nov 2006
Hi All
I would like to set a formula in each of the relevant cells in Row 1 to
display the column width (30 of them of different widths).
Any ideas would help. Rgds KZ

 
Reply With Quote
 
 
 
 
Paul B
Guest
Posts: n/a
 
      7th Nov 2006
Kieranz, try this,

Public Function CW(C As Range)
'Will show column width
'use like this = CW(A1)
Application.Volatile
CW = C.ColumnWidth
End Function

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Kieranz" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi All
> I would like to set a formula in each of the relevant cells in Row 1 to
> display the column width (30 of them of different widths).
> Any ideas would help. Rgds KZ
>



 
Reply With Quote
 
Kieranz
Guest
Posts: n/a
 
      7th Nov 2006
Hi All
I got it, from UG. In each cell in the first row put =CELL("width",A1)
and copy across.
Thks.
Rgds
KZ
Kieranz wrote:
> Hi All
> I would like to set a formula in each of the relevant cells in Row 1 to
> display the column width (30 of them of different widths).
> Any ideas would help. Rgds KZ


 
Reply With Quote
 
Kieranz
Guest
Posts: n/a
 
      7th Nov 2006
Hi Paul
Many thks, works perfect. My suggest doesn't give the decimals. it
rounds up.
Rgds
KZ

Kieranz wrote:
> Hi All
> I got it, from UG. In each cell in the first row put =CELL("width",A1)
> and copy across.
> Thks.
> Rgds
> KZ
> Kieranz wrote:
> > Hi All
> > I would like to set a formula in each of the relevant cells in Row 1 to
> > display the column width (30 of them of different widths).
> > Any ideas would help. Rgds KZ


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to compare the max width of a cell compared to the max width of awksht page? Chet Microsoft Excel Programming 1 19th Feb 2008 03:00 AM
dropdownlist expand display width not control width Ganesh Microsoft ASP .NET 0 16th Nov 2007 05:22 PM
How can I restrict cell data display to column width? =?Utf-8?B?U2FsbHk=?= Microsoft Excel Misc 0 6th Jan 2006 06:32 PM
Is it possible to measure/display the column width with a cell function? J Microsoft Excel Discussion 4 7th Jul 2005 03:54 PM
setting cell width in data sheet and subreport width =?Utf-8?B?Q2hyaXM=?= Microsoft Access Forms 0 27th Apr 2005 11:07 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:23 PM.