| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Altered Column Width
Folks:
In use one column of my spreadsheet to import a text file. Each day I run a refresh on the data. However, after refreshing this data, I notice that the width of the column into which data is received gets altered. * How can I prevent the width of the single column from being changed as I import data from a text file ? Thanks, John. |
|
#2
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Altered Column Width
Refresh with a macro that has one line to reset the column width
columns(5).columnwidth=12 -- Don Guillett SalesAid Software <JoJo wrote in message ... Folks: In use one column of my spreadsheet to import a text file. Each day I run a refresh on the data. However, after refreshing this data, I notice that the width of the column into which data is received gets altered. * How can I prevent the width of the single column from being changed as I import data from a text file ? Thanks, John. |
|
#3
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Altered Column Width
"Don Guillett" wrote...
Refresh with a macro that has one line to reset the column width columns(5).columnwidth=12 .... Or store the column width in a variable first, import into the column, then restore the saved column width. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Altered Column Width | Excel Discussion (Misc queries) | |||
| how do I create multiple column width in the same column in excel | Excel Discussion (Misc queries) | |||
| How to make cell width different than the column width it lies in | Excel Discussion (Misc queries) | |||
| Varying column width in a column chart | Charts and Charting in Excel | |||
| Change the width of a single column in a column chart | Charts and Charting in Excel | |||
Linear Mode
