Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
fixing column width
We create on a regular basis from Excel space delimited files for import to
other programs that require the width of the columns to be fixed. Problem has come up that depending on which computer we are looking at the same file a column width may be the required 4 characters wide but on the next computer it show as 3.87 characters wide. How do we get the column width to stay fixed at 4 no matter what computer is viewing the file? If it was only one column this would be easy but we are talking about many columns that all are okay on one computer but not on the other computer. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
fixing column width
One workaround would be to create the following macro and save it in your workbook: Sub auto_open() ' Sheets("Sheet1").Select Cells.Select Selection.ColumnWidth = 4 Range("A1").Select ' End Sub -- scoobz ------------------------------------------------------------------------ scoobz's Profile: http://www.excelforum.com/member.php...o&userid=12170 View this thread: http://www.excelforum.com/showthread...hreadid=561339 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column Width | Excel Discussion (Misc queries) | |||
Changed column width keeps reverting back to original size | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Change the width of a single column in a column chart | Charts and Charting in Excel | |||
Column Width | Excel Discussion (Misc queries) |