Is there a way to export a highlighted section of a worksheet to a
text file?  Or is there a way to only export parts of a spreadsheet
that have data in them?

For example, I have a spreadsheet with many hidden formulas from rows
1 - 100.  Sometimes only rows 1-12 have data.  If I save the
spreadsheet as text, the empty rows (13-100) show up with a set of
columns.

For compliance reasons, I can not incorporate a macro.

Any ideas?

Thanks!