Add-in to search and delete

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is it possible to add a Search Box within a spreadsheet? 1
Deleting specific information 3
Fails to delete empty rows 4
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel Worksheet_change with 2 functions to insert date and hyperlink window 0
Help! Can’t debug macro used to delete duplicate rows 2
Delete Specific Contents 10
Inserting additional rows and only copying certain columns 1

Back
Top