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

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

SEHRA,

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

Sub ClearRangeMacro_for_SEHRA()
    
    Sheets("Sheet1").Range("A1:B10").ClearContents
    
End Sub

Hope that helps,
~tigeravatar

Thanks a lot