Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
search/delete duplicate entries in excel '02? | Excel Worksheet Functions | |||
keyword search and delete row | Excel Discussion (Misc queries) | |||
Search & delete ANY text in select columns | Excel Discussion (Misc queries) | |||
Search and Delete | Excel Programming | |||
Macro to search, compare, copy and delete | Excel Programming |