Code that finds and deletes names from current sheet to all worksheets in workbook

Hello!

Currently I have code that searches for an individual's last name in column A , finds the row, and deletes the row. This works perfectly on the active sheet I am on. (Inspiration from http://tinyurl.com/m5mbanb)

In my workbook, I have several worksheets corresponding to each week of the year. I hope to have the code I have iterate through each worksheet and delete the same name from Column A in each worksheet. The catch is that the name will not be in the same row on each sheet. Thus, the string needs to be found again on each sheet.

I have attempted to use a For each statement; however, that yields an error. Additionally I have attempted to set up array variables where the name location can be saved but I have been unsuccessful

Please Login or Register  to view this content.

Code:

Please Login or Register  to view this content.

When I have the For each loop in, I receive a "Delete method of range class failed" error, and the code that is highlighted is

Please Login or Register  to view this content.

If anyone has any thoughts, I would really appreciate it.

Best,

Grazian2

Untested

Please Login or Register  to view this content.

AB33,

Thank you for your reply. Unfortunately, the code you posted was the code I mentioned I tried. When I run the code with a For each loop I get a When I have the For each loop in, I receive a "Delete method of range class failed" error, and the code that is highlighted is

Please Login or Register  to view this content.

It would be great if you have any more input

AB33,

Thank you for your reply. Unfortunately, the code you posted was the code I mentioned I tried. When I run the code with a For each loop I get a When I have the For each loop in, I receive a "Delete method of range class failed" error, and the code that is highlighted is

Please Login or Register  to view this content.

Try this modification to you "For Each" loop and see if this works better.

Please Login or Register  to view this content.

Alf

Alf,

Thank you for the reply!

Unfortunately, I still receive the same error.

I found that if I use

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.

I did not get an error.

Then, I sort each worksheet by column A and the row that had its contents cleared is moved to the bottom.

Thank you all for your help!

Grazian2

Attempted to answer in error