removing word wrap from a text file

[dtittle]

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.

[Chip Pearson]

Try
Range("A1").WrapText = False


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


"dtittle" <dtittle@microbeef.com> wrote in message
news:1142272420.926344.8500@z34g2000cwc.googlegroups.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.
>

[dtittle]

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.