Delete the same ranges in mutiple sheets

[Dibbley247]

Hi

I was wondering for future reference if it's possible to shorten down the following code, in a way, not to repeat it 14 times as there are 14 sheets, and the ranges are identical to each sheet? The amount of times, I do something, someone says...."you can do it this way"

So wondering if there is a way to change what I have copied and pasted 14 times, but changed the sheet names?

Please Login or Register  to view this content.

Thanks

[stnkynts]

Please Login or Register  to view this content.

[TMS]

Please Login or Register  to view this content.

Regards, TMS

[Bob Phillips]

Please Login or Register  to view this content.

[Dibbley247]

Thanks. I'll use the ones where I still have to name each shert, as I have others that dont need deleting, and guessing if I use the one that says only "each ws" it'll do it to every sheet.

[TMS]

You can use, for example,

Please Login or Register  to view this content.

and list the sheet names in the array.

Or, to make it more flexible, you could list the sheets on a Control/Configuration worksheet and then loop through the list.


If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.