Add-in to search and delete
 

Hi everyone

Is there an add-in or code available to allow the user to enter a name,
number value etc. to find, then if found allow the user choices whether to
delete entire row or clear cell contents or change cells value.
Also allow user to enter a column number or letter to search on.
Very similiar to Find and Replace but with "Specific Column to search on"
selection and "Delete EntireRow" as extra bonus.
--
Thank you

Regards

Bob C
Using Windows XP Home + Office 2003 Pro

Add-in to search and delete
 

Use input boxes to prompt for all the information you want and assign the
information to variables. Then use the Find command. If the target is
found, then use a case statement with the variable that defines the type of
action to perform.

set rng = columns(i).Find(ans)


--
Regards,
Tom Ogilvy

"Robert Christie" wrote in message
...
Hi everyone

Is there an add-in or code available to allow the user to enter a name,
number value etc. to find, then if found allow the user choices whether to
delete entire row or clear cell contents or change cells value.
Also allow user to enter a column number or letter to search on.
Very similiar to Find and Replace but with "Specific Column to search on"
selection and "Delete EntireRow" as extra bonus.
--
Thank you

Regards

Bob C
Using Windows XP Home + Office 2003 Pro