Hi, I found a link to this site on a different post. you'll have to change
"ron" to 1 and your row name but it works fantastically for me.

http://www.rondebruin.nl/delete.htm



"dinadvani via OfficeKB.com" wrote:

Hi there,

I have a sheet which has some subtotals in it. Now I want to delete the rows
for which the subtotal count is 1

Please help

Thanks,
Dinesh

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200606/1