Clear contents of last used cell in a range and those previous to it (excel 2003)

Hi

I have two sheets with cells in ranges that I want to be able to clear the contents of. Sheet2 range is A2:C30 Sheet6 range is A10:C30.
So for example, in sheet6 if all of the cells in the range have content and I hit the clear button it would clear the content in C30.
If I hit again it would then clear the content in B30 and again the content in A30. If I repeatedly hit the button it would clear the
content all the way back to A10. Within this range there could be some blank cells, but I assume since its blank the code would
find the next used cell prior to it. It must stop at A10 as there is data in cells previous to this that I don't want to clear. I have
managed to clear contents of entire rows in this range but have not been successful for individual cells.

Thanks
Chris

Hey Leith, Mike
Thanks for the nice solutions! This is essentially the "undo" button I had be wanting to integrate into the code for a while now.

Chris