![]() |
|
#32
|
|||
|
|||
|
*Note: I wish I cold delete previous posts so you don't waste your time responding to them. I am here for 8hrs each day, so I tend to fiddle with things throughout the day. I managed to Group the Phases successfully. I'll try to figure out if I can delete, in which case, if you don't see any posts preceding this one, then I figured that out too!
Now, I'm sorry, but I can't give up on this whole 'TextToColumns' piece.. it actually kind of gives me something to do while awaiting responses I did a lot of googling today, and at least managed to select the range of E2 End(xlDown)- so that much I have figured out! I even found out what Array 0, 9 and 3, 3 means. That it will skip the first column, and format the second to the date format of MDY (9= xlSkipColumn, 3 = xlMDYFormat ). But what i can't quite understand is why it won't actually do the task of splitting the data out. I feel like I will eventually figure it out for myself, but at the same time, whatever I return in my google searches, I'm never quite sure I'm looking at the right thing haha.Now my code appears as: Range("E2").Select Range(Selection, Selection.End(xlDown)).Select Selection.TextToColumns Destination = Range("E2") DataType = xlFixedWidth FieldInfo = Array(Array(0, 9), Array(3, 3)) My last thought to this is: is "TextToColumns" a FUNCTION? and perhaps if I identify it as such, it will actually perform the task? |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Formatting contents after Tab of continuous lines or formatting specific area of word | pawii | Word | 1 | 05-12-2014 05:24 AM |
| macros | stebrownsword | Word VBA | 0 | 08-28-2013 01:16 AM |
How to do Formatting Using Macros
|
anju16saini | Word VBA | 1 | 03-11-2013 04:15 AM |
Formatting with macros
|
WaltR | Word VBA | 8 | 05-15-2012 06:28 PM |
| Macros | nore | Outlook | 0 | 06-01-2011 04:39 PM |