Sorry, Bob, that I'm jumping the gun here. But I was trying to do something on my own (you know, my whole trial and error method). Can you look at the code below and tell me what I'm actually telling the program to do? haha

SelectRange = ("E2.End(xlDown)")
DataType = xlFixedWidth
FieldInfo = Array(Array(0, 9), Array(3, 3))
TrailingMinusNumbers = True
SelectRange = ("F2.End(xlDown)")
DataType = xlFixedWidth
FieldInfo = Array(Array(0, 9), Array(3, 3))
TrailingMinusNumbers = True
Columns("E:F").Select
Selection.NumberFormat = "ddd, mmm dd"

This code actually deleted the contents of columns J, K, and L. Didn't color the rows based on our previous criteria of Phase and Sub-Phase, and left me with columns E and F highlighted but not formatted (the export itself presents the dates as, for example, Fri 6/6/14. And it is just "general"- so I cannot format it unless I delete the preceeding 3 characters, and format the rest as a date).

My intent:
1. Start with Cell E2, and select E2 to the "last" cell (using your handy dandy End.(xlDown) !)
2. Text to Columns: Fixed Width. Split after first 3 characters. Do not import the first 3 characters, and import remaining column as a Date
3. Then, start with cell F2, and select F2 to the "last" cell.
4. (repeat step 2)
5. Format columns E & F as "ddd, mmm dd".

I tried a number of different things to get it to do what I wanted it to. One being:

Set cz = Range("E2").End(xlDown)
SelectRange = cz
DataType = xlFixedWidth
FieldInfo = Array(Array(0, 9), Array(3, 3))
TrailingMinusNumbers = True
Set cz = Range("F2").End(xlDown)
SelectRange = cz
DataType = xlFixedWidth
FieldInfo = Array(Array(0, 9), Array(3, 3))
TrailingMinusNumbers = True
Columns("E:F").Select
Selection.NumberFormat = "ddd, mmm dd"

However, when I did that- it, for a reason unknown to me anyway, took the data in columns A and B and at a minimum reformatted it to the number format I suggested. So I know I at least have the formatting correct! It's performing the text to columns in the appropriate cells that I am clearly not presenting correctly.

You can respectfully choose to skip this post for the time being, considering we were working on something else before I decided to go off on my own rampage

I had actually written the code several different ways before I even managed to get the Macro to run (trial and error!!). When it finally did, I tweaked it several more times before I actually realized a result (T&E!). And from there, I tried the 2 above examples and could not go any further, as I did not know what was causing it to fail (just E, here).