Clear the Specific Range of Cells Using a Command Button

Hi All,

I was trying to solve a small thing which i am unable to do.

I am having a Excelbook With 4 sheets. I Inserted a Command button to clear the cells in Sheet 2. Now, I want to clear the Cell Content in Sheet3(From the Cell A5 to C(xldown)) also, using the same command button which is in Sheet2. i.e, if i click Clear Button from Sheet2 it should clear both Sheet2 values as well as Sheet 3 Values.

Is it possible to delete the sheet3 contents? If yes, tell me how

Thanks in Advance
Abinaya

Hi Ady,

Thanks for your help.

I am getting error in the line "lngLastCell = Sheet("Sheet3").Range("A:C").Rows.Count"

I have attached a sample file. Please see that.

Regards,
Abinaya..

Originally Posted by Blokeman

Did you rename Sheet3?

Yeah. i have renamed the sheet3. after that, i didn't get any error message. but the contents of cells from Sheet3 has not getting delete when i click on clear button.

Could you please help me in this?

Hi all,

I got it. I did few changes. Now it is working fine. Thank you so much guys.