Clearing cells using command button in different sheet

[chemi9]

Hi All,

I have a commandbutton1 in sheet1 and I want to clear range of cells in sheet2. I'm using following commandbutton_click code,

Please Login or Register  to view this content.

Above code won't clear the cells I want. When I use for loop it works but it takes forever,

Please Login or Register  to view this content.

Is there a effective way of clearing cells in sheet 2?

Thanks

[Olly]

Please Login or Register  to view this content.

Works fine for me...

Maybe attach your workbook, so we can see what's going on.

[stnkynts]

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Sheet2 and Sheets2 are not the same thing. Indexing (Sheet2) may be causing you an issue if the second sheet in the index is actually a different sheet than you want it to be. If your sheet has a static name is should be referenced that way.

[chemi9]

Thanks for the reply, here's the actual code I'm using where "Data" is my sheet2, But the command button is in Sheet1

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[stnkynts]

Run this independent macro to see if this clears it to where a blank message box pops up. If there is a value in the message box let me know if it is 1 value or 2.

Please Login or Register  to view this content.

[chemi9]

Sorry for the delay. My initial code is working now. Thanks for all the replies.