Clear button

[geliedee]

Hi Guys,

Can you help me in this problem. I have here a file and i need a clear button.
the Data starts at a6 and up to x6. Please see the image. and i need to clear starting from column A6 to x6 and down the rows. I used the code below but it doesnt seem to work. Hope you can help me.

Please Login or Register  to view this content.

Capture.JPG

[bmouse]

Not sure what you tried to do with defining all those properties as I'm a VBA noob, but...

If all you need is clear the area, then this is how to. I think.

Please Login or Register  to view this content.

[watersev]

hi geliedee, sort of that:

Please Login or Register  to view this content.