Delete Data- -command button

[grkchakri]

Can i create a command button to clear values in sheet 1 and sheeet 2 simultaneously , button being in sheet 1. i want to clear
data in sheeet2 also.

I am able to do it for sheet 1 and for sheet2 when i am declaring the sheet under command click code
it was giving an error message and data from sheet2 doesnt go





MANY THANX

[johnjohns]

I recorded a macro while clearing the values manualy. Here is the result

Please Login or Register  to view this content.