Deleting cells in multiple worksheets at the same time

[ilovejazzmusic]

I want to do something which surely can't be that difficult.
I have a file with two worksheets: table and knockout
I use it to score a computer tournament i play.
At the end of the tournament I want to clear certain cells from both worksheets.
in the worksheet called "table" i want to clear cells C15:c18, j15:j17, q15:q18, c100:t105
in the worksheet called "knockout" i want to clear cells d2:g6
That's all.
How do i write a macro that will delete those ranges of cells from both sheets at the same time? ideally, i'll then put a button somewhere. pressing the button will clear those cells.
i've spent some time with trialling and erroring, but mostly erroring, to be honest.
thanks people
ilovejazz

[jasoncw]

Hi jazz.

The easiest way for you to learn this is by recording a macro. Tools > Macro > Record, then perform your operations, then click the Stop button. Of course, the code written during the recording is not the most efficient, but it will work. After cleaning it up, it could be simplified to something like:

Please Login or Register  to view this content.

HTH

Jason

[ilovejazzmusic]

good one mate. cheers.

[royUK]

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

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