Nothing in your code to indicate these "^M" chars were added, so I can only
assume they are in the cell values.
Check the source data.

Also, check the help for "FreeFile".

NickHK

"gordian" wrote in message
ups.com...
I'm new to Excel vba programming, so I'm not sure if I'm doing the
right thing.

In my macro, if I do:

'''''''''''''''''''''''''''''''''''''''''''''''''' ''''''

Dim fileName As String
Dim colIndex As Integer
Dim rwIndex As Integer

fileName = "test.txt"
colIndex = 4

Open fileName For Output As #1

For rwIndex = 2 To 10
Print #1, Cells(rwIndex, colIndex).Value
Next rwIndex

close #1

'''''''''''''''''''''''''''''''''''''''''''''''''' ''''''

What I got in the output file were lines that ended with "^M". How can
I remove these characters?

Thanks