Ok...I created a macro to give me a head start with a command button. I need the VBA coding to select all the cells on a given worksheet. The macro used:

Cells.Select

All sources I have seen so far indicate that this should be correct, however, once the code was copied from the macro to the command button I keep getting the following error:

Run-time error '1004':
Select method of Range class failed.

So, why on earth does it work in the macro, and not for the command button?
Any ideas?

Thanks,
Amber