![]() |
|
#36
|
|||
|
|||
|
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 |
|
|
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 |