Thanks all. I am totally blonde, I completely forgot about using the
Macro Recoreder. I'll have to take some blonde juice later! :)

Now that I've got the data sorted, What I'm looking to do is write to a
file the specific rows I sorted on. One record per line.

I know, it sounds re-dundant, but it's part of a larger picture.

fyi. the column value for the records I need write is x. if there's
an x in that comlumn for a record, write the record to a text file.

Now, since it's been over a decade since I last coded, I can't figure
out to start with what kind of loop to do. For, while, etc.

How would I read the data from Excel into an array (that's the key so
far).

BTW, the code that the macro created was very easy to read and edit
(had to take out a bunch of windows scroll (ex:
ActiveWindow.SmallScroll ToRight:=14) statements.

Thanks again all!
-Michael