| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do you insert into a excel cell the column width automaticall
How do you insert into a excel cell automatically the column width?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do you insert into a excel cell the column width automaticall
This formula returns the column width of the cell it is in: =CELL("width")
It rounds to the nearest integer however. If you wanted something more exact you'd have to use a macro. If you put this in a standard module: Function ColWidth() Application.Volatile ColWidth = Application.ThisCell.ColumnWidth End Function Then you can enter =ColWidth() in a cell. -- Jim "Paul" wrote in message ... | How do you insert into a excel cell automatically the column width? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do you insert into a excel cell the column width automatic
Hi, I am not very macro efficient. Can you advise how I set it up and
include it as a tool bar button. Thanks "Jim Rech" wrote: This formula returns the column width of the cell it is in: =CELL("width") It rounds to the nearest integer however. If you wanted something more exact you'd have to use a macro. If you put this in a standard module: Function ColWidth() Application.Volatile ColWidth = Application.ThisCell.ColumnWidth End Function Then you can enter =ColWidth() in a cell. -- Jim "Paul" wrote in message ... | How do you insert into a excel cell automatically the column width? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do you insert into a excel cell the column width automatic
If you want a message box to pop up with the current column's width you
don't really need one. Just click on the column separator at the top of the worksheet. For instance, to see column A's width just click and hold on the bar between "A" and "B". -- Jim "Paul" wrote in message ... | Hi, I am not very macro efficient. Can you advise how I set it up and | include it as a tool bar button. | | Thanks | | "Jim Rech" wrote: | | This formula returns the column width of the cell it is in: =CELL("width") | | It rounds to the nearest integer however. If you wanted something more | exact you'd have to use a macro. If you put this in a standard module: | | Function ColWidth() | Application.Volatile | ColWidth = Application.ThisCell.ColumnWidth | End Function | | Then you can enter =ColWidth() in a cell. | | -- | Jim | "Paul" wrote in message | ... | | How do you insert into a excel cell automatically the column width? | | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automaticall e-mail me when cell value reaches a value | Excel Worksheet Functions | |||
| Automaticall pick up info from a cell from a shet t oanither sheet , in the same cell, same book | Excel Worksheet Functions | |||
| How can I adjust column width of a single cell within Excel 2003? | Excel Discussion (Misc queries) | |||
| How to make cell width different than the column width it lies in | Excel Discussion (Misc queries) | |||
| Same column, different cell width at different row | Excel Discussion (Misc queries) | |||
Linear Mode
