I think I figured it out...the next row has cells with formulas in it.

"Chip Pearson" wrote:

David,

The code works as expected for me. Do you have the SelectionOnly parameter
set to True? If so, you MUST select the entire range of data you want to
export. Otherwise, it will export only the active cell. If you want to
export the entire worksheet, make sure SelectionOnly is False.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com
(email address is on the web site)



"David" wrote in message
...
The first row is blank and shows all "" correctly. The 2nd row shows the
data
correctly also, but stops on the 2nd row.

I'm using and trying to get Chip's code to work and it will not go past
the
2nd row. I have 42 rows of data and 12 columns. I'm using his export code
from: http://www.cpearson.com/excel/imptext.htm#Export

I have data in rows 3-42, with some blank rows and in columns A-I with
some
blank columns. I also have a few buttons, but do not expect/need those
exported.

I'm using this to export setups, and then reimport then into the same
worksheet. Any help would be appreciated.