macro code for delete range of cells in several Pages

[hoomantt]

Hi Dear Professors
i need a help
in my example attached file(TEST), i need a macro that when i click on recycle bin image in "MENU" Page:
then clear just data in cells in some of ranges in several pages like this:
page USA , Range A3:C5
Page Italy , Range A2:B4
Page china , Range A5:C9
Please, Please help me

 

[vletm]

hoomantt
You can continue with this sample...

Sub Hoomantt()
    Sheets("USA").Range("A3:C5").Clear
    Sheets("Italy").Range("A2:B4").Clear
'   and so on ...
End Sub

 

[pecoflyer]

Are VBA questions not supposed to be posted in the relevant subforum?
by Moderator: Yes, as well as all questions and answers.

 

[jolivanes]

Or something like the attached.

 

[vletm]

This thread has duplicate to

Ask A Question Before Run A Macro

please help me to write a code that if some one clicks on trash icon in my excel attached file that clear some ranges in some worksheets , first open a window to ask from user that are you really want to delete all these data? then if user click on "yes" button then run macro and if user click...

chandoo.org

This older thread is closed now.