Delete Rows

  • Thread starter Thread starter Bernie
  • Start date Start date
B

Bernie

I would like to be able to delete a row with a name in it based on a
cell with that name from another cell in a different worksheet. Any
ideas?

Thanks,
Bernie
 
That worked great, thank you so much.

How do I run the same macro for another name right after this one?

Bernie
 
I want your macro to delete a row in 4 diffferent sheets using a name
in a cell from another sheet all at the same time.

Bernie
 
Or if many sheets in workbook may be easier to put the 5 you want into an array.

If many sheets you could put the 5 sheets in an array

For Each W In Worksheets(Array("sheet1", "Sheet3", _
"Sheet5", "sheet7", "sheet9"))


Gord Dibben MS Excel MVP
 
Thank you very much for all of your assistance.

I am going to have too many sheets to avoid. I would rather name the
sheets I want to scan.

Thanks, Bern
 
Don't know where you have entered the code.

Did you plug it into the code provided by Gary's Student?

Post the code you're using.


Gord
 
Back
Top