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
Bookmarks