Delete Rows

[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

 

[Bernie]

That worked great, thank you so much.

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

Bernie

 

[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

 

[Bernie]

I don't want it to look at all the sheets, just 5. How do I name them?

Bernie

 

[Gord Dibben]

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

 

[Bernie]

Thank you. I get the error message of Run Time Error 438. What do I
do?

Bern

 

[Bernie]

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

 

[Gord Dibben]

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

 

[Bernie]

Actually they all didn't work. I am looking for all new code that
works.

Thanks,
Bernie