Expand 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.

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

Best,

Grazian2