I will assume that you have some VBA experience if you have gotten this far
on a project like this. You can try a couple of things.

Option 1
Find a column in the worksheet that always has data. That is your constant.
Loop through all rows in the worksheet where that cell is not empty. Delete
the rows that have bad data based on the evaluation of another column.
Export the data when all bad rows have been deleted.

Option 2
If you can't delete rows, your coding get's a bit more complicated. You can
write each row to a file individually, eliminating the bad rows.

Option 3
Another option that might work if you can't delete records is to make a
temporary copy of the sheet and delete the rows you don't want to export.
Export the data then delete the sheet.

Let me know if you need further explanation.
--
Happy Coding,

Scott


"jhs626" wrote:

I have 30+ worksheets that contain formula values for export (as space
delimited txt files). w/ a UserForm I want the user to choose 1 worksheet
from a ComboBox and press 1 of 2 cmd buttons

cmd button 1 - go to sheet
cmd button 2 - export txt file - to location of choice

--- tricky part
All worksheets have varying # of rows and I'd like to avoid exporting rows
like the 2nd row below:
---
M-SYMB-P100 92 CONTINUOUS 0.50
M- #N/A #N/A #N/A
---
Thanks for any help
--
JS