I was actually wanting to use a filter to gain the row of information I need
and export them to the text file using a button with a macro attached if it's
possible.

"Dave Peterson" wrote:

Copy those visible cells to a new worksheet nad save from there (as .txt)?

Select your range
edit|goto|Special|visible cells only
edit|copy
to the new sheet
edit|paste



Josh Brien wrote:

How do I export only the visible cells, not the hidden ones, in an Excel
spreadsheet to a text file?

--

Dave Peterson