| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display col width in a cell
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Display col width in a cell
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" wrote in message oups.com... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Display col width in a cell
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Display col width in a cell
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change Cell Width WITHOUT changing Column width | Excel Discussion (Misc queries) | |||
| How can I control the full screen display width ? | Excel Discussion (Misc queries) | |||
| How to make cell width different than the column width it lies in | Excel Discussion (Misc queries) | |||
| How can I restrict cell data display to column width? | Excel Discussion (Misc queries) | |||
| Shortcut key to display change the display from displaying cell values to cell formulae | Excel Programming | |||
![Kieranz[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
