Excel 2007 : clear a range of cells on non active sheet with macro

[SEHRA]

Dear all,

Kindly advise me what is the Vba code to clear a range of cells from a non active sheet with a macro. I have two sheets where on sheet 2 i have a rectangle autoshape which will be use as a buton.

Regards

[tigeravatar]

SEHRA,

You can use the following. Change the sheetname and range as necessary:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

[SEHRA]

Thanks a lot