Home > Excel Tutorial > Excel Vba : Find And Delete In All Workbook

Excel Vba : Find And Delete In All Workbook

Loop Through Workbook

         Value that you want to delete is found with macro.

With the opened msgbox ,found value’s address is reported ,and you are asked whether you want to delete.
If you click “Yes” button on the msgbox, the row that contain value is deleted as whole.

“Xlpart” was selected as the search method of “Find Method”:

Set bul = Range(Cells(3, 1), Cells(Cells(Rows.Count, 1)._”
End(xlUp).Row, LastColumn)).Find(WhatToFind, LookAt:=xlPart)

Excel find and delete

Download Example File

 

  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: