| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set column width to fixed size if there's no data in it at all(except heading in row1)
Hello,
Simple question, but...€¦ what's the answer :) Somebody knows it ? Thanks ! In a sheet there are many columns, but a few of them hasn't registered data in the rows. When using Cells.EntireColumn.AutoFit it's allways on a size that could be a bit smaller. Therefore I like to run a macro that runs from first column to last used and check in each column if there is data (in row 2 till last used row). If not, then set the column width on 10. Regards, Johan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fixed Column Width Export | Excel Discussion (Misc queries) | |||
| Column fixed width | Excel Discussion (Misc queries) | |||
| Text to column, fixed width | Charts and Charting in Excel | |||
| Text to column, fixed width | Excel Discussion (Misc queries) | |||
| Help: How do I create a column of fixed width data? | Excel Programming | |||
Threaded Mode
