View Single Post
 
Old 06-24-2014, 09:35 AM
EC37 EC37 is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
 
Join Date: May 2014
Location: Waltham, MA
Posts: 56
EC37 is on a distinguished road
Default

Hooray!

but yes, I think it had to do with selecting the cells because this was the problem originally before you decided not to persue showing me TextToColumns

Set cz = Range("E2").End(xlDown)
SelectRange = cz
DataType = xlFixedWidth
FieldInfo = Array(Array(0, 9), Array(3, 3))
TrailingMinusNumbers = True

So multiple problems. The setup to select the cells and the way the statement was set up.

What say ye 'ol wise one? haha
Reply With Quote