Export Worksheet Data Problem

[Guest]

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.

 

[Chip Pearson]

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)

 

[Guest]

It was set to true, I set to False.
I tried the entire spreadsheet option, only did the first two rows again.
I tried just selected and it only did the first cell.
I "selected" all the cells with data (A1:L42) and tried both again with the
same result, but I did the selection manaually.
Should I put the selection in the code?
Could I send you my worksheet?
Let me know and thank you much for your assistance.

David

 

[Chip Pearson]

Send the workbook to (e-mail address removed) and I'll have a look at it.


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

 

[Guest]

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