From: rcarolina on
I have a large mailing listing that I have to delete names from. I have
created a macro that "finds" CPA and deletes the entire row from the
spreadsheet. How do I make this macro continue throughout the spreadsheet
without running it by hand every time? I am running Excel 2007.
Thanks,
--
rcarolina
From: Don Guillett on
Look in the vba help index for FINDNEXT

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"rcarolina" <rcarolina(a)discussions.microsoft.com> wrote in message
news:60752F79-5B58-446D-8C03-BCB0EB8198E0(a)microsoft.com...
>I have a large mailing listing that I have to delete names from. I have
> created a macro that "finds" CPA and deletes the entire row from the
> spreadsheet. How do I make this macro continue throughout the spreadsheet
> without running it by hand every time? I am running Excel 2007.
> Thanks,
> --
> rcarolina