Selecting all cells in a worksheet using commandbutton

Something strange (at least for me).
When I record a macro that selects all the cells in a workbook and clear all content the code looks like this:

Please Login or Register  to view this content.

This works fine. However when I have the same code inside a commandobutton it fails and gives me the error code "application-defined or object defined error". Anyone that knows why and how this can be done correct? I want this to be done within the commandbutton code.

The code that fails looks like:

Please Login or Register  to view this content.

I would do this :

Please Login or Register  to view this content.

This would work anytime, anywhere in your workbook.

Thanks,
Vikas