Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is it possible to get the width of all of the visible columns?
Would this work? Worksheets("Sheet1").Activate Windows(1).VisibleRange.Width Would it be possible some how predetermine the width of a label on a sheet, before entering text into it? Basically I would like to know the width of the label given a font and some text before adding the text to the label. The reason I would like to do this is to test to see if the label is going to go outside of the visible range (which results an error). I was thinking that I might have to put the label on a hidden sheet first and test its width there and then put the text on the visible sheet. Would a label on a dialog box with same font/text have the same width as one in a sheet? Thanks, David |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Change Cell Width WITHOUT changing Column width | Excel Discussion (Misc queries) | |||
ASC() does not convert full-width to half-width letters (Exel 2003 | Excel Worksheet Functions | |||
Determine a cell's width and enter it in the cell | Excel Discussion (Misc queries) | |||
Open JPG and determine pixel width in VB? | Excel Programming |