Thanks Dave
Really looking for code to run from the click method on a button object.
The user (My wife) needs a 1 click solution as she has to do several of
these every week.
Cheers
Neil
"Dave Peterson" wrote in message
...
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