removing word wrap from a text file
 

I am Importing a text file with my macro, and need to remove the word
wrap before Importing. Can I do this in the macro itself? Right now I
am doing this manually before I run the macro.

removing word wrap from a text file
 

Try
Range("A1").WrapText = False


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"dtittle" wrote in message
ps.com...
I am Importing a text file with my macro, and need to remove the
word
wrap before Importing. Can I do this in the macro itself?
Right now I
am doing this manually before I run the macro.

removing word wrap from a text file
 

I was wrong, I want to add the wordwrap. Before I Import the .txt
file, wordwrap is turned off. When WrapText = Ture (it should wrap the
text, correct?) because wright now, it is not.