Posted 20 January 2006 - 11:06 AM
Posted 20 January 2006 - 11:39 AM
Posted 20 January 2006 - 12:04 PM
Posted 20 January 2006 - 12:10 PM
Posted 20 January 2006 - 07:29 PM
It is possible to do this in either all or only selected workbooks. I would assume that you would require the column width to be "autosized" size in specified workbooks only. This can be achieved by adding the following code into the ThisWorkbook object using the VBA editor. This will only affect the workbook that you insert the code into.
Private Sub Workbook_Open()
Dim i As Integer
For i = 1 To Sheets.Count
In the above example all sheets in the workbook are affected and I have selected the first 52 columns of each sheet to be autosized. If you require more help on this (eg. set column width or only selected sheets) let me know and I shall help, if you are confident enough have a play with the code and set it to suit your needs.
Edited by Octagonal, 20 January 2006 - 07:30 PM.
Posted 21 January 2006 - 12:40 AM
Posted 21 January 2006 - 12:52 AM
Edited by Octagonal, 21 January 2006 - 12:55 AM.
Posted 21 January 2006 - 01:07 AM
Posted 21 January 2006 - 01:25 AM
Open a blank worksheet and in cell A1 type in something like 11,25,you,26,39,me (something similar to your data.
1. Then highlight the cell then select the Data menu and select Text to columns.
2. A dialog box will open where you set how the data is to be seperated. In this case choose the Delimited option and hit the Next button.
3. Uncheck the Tab box and check the Comma box the click the Next button.
4. Set the column data types then click Finish. You will now find that the data is in seperate columns now.
To do this with several rows of data, simply highlight the entire column that you wish to seperate when selecting the data that you wish to use in the first step. If you feel comfortable doing this, then try it on a copy of your spreadsheet first.
Let me know how you get on.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users