I would record a macro when I applied Data|filter|autofilter (add headers if you
have to).

Show the 0's in column A.
Select those visible rows
F5 (or ctrl-g or edit|goto)|special|visible cells only

And paste into a new worksheet in a new workbook.

Then save that new workbook as a .csv file

Close (without saving) that new workbook.

"msnews.microsoft.com" wrote:

Hi
Having trouble with code to do the following.
Worksheet has data in columns A to F and rows 1 to 42.
I wish to export to CSV file all the rows except rows with the numeric value
0 in column F

I have done some VBA programing but not for a while so having trouble
getting started.

Any help would be greatfully accepted
Thanks
Neil

--

Dave Peterson