The underscore is a continuation character and is used
to indicate that the next line is a continuation.

You should have gotten a syntax error and line(s) in the macro in RED.

You will frequently have such problems in copying a macro from
a newsposting due to line wrap. But this should not happen when
copying from a web page. The web page should have been fixed
after telling you what was wrong with your (adopted) code.

Pasting macro code into a module sheet (XL95), or into VBA Editor (XL97 & XL2000)
http://www.mvps.org/dmcritchie/excel/install.htm
You want to make both the Excel and the web source windows as wide as possible. Pasted lines or any other lines turn RED if there
is a syntax or other easily recognizable problem in Excel. An underscore at the end of a line indicates a continuation. Splitting
a line without the continuation character is the most frequent syntax problem and code lines turn red as soon as continuation or
other syntax errors are detected. Actually the continuation character is really two characters, a space followed by an underscore.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"saturnin02" <saturnin02_at_hotmail.com wrote in message ...
Chip,
You were absolutely right! I put the 'Sep As String' and 'SelectionOnly As
Boolean' on the same line and it works.
What is the "_" at the end or within some of the lines?
Tx for your help!