View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Amber_D_Laws[_8_] Amber_D_Laws[_8_] is offline
external usenet poster
 
Posts: 1
Default Code created in a Macro not working for a Command Button


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 :)


--
Amber_D_Laws
------------------------------------------------------------------------
Amber_D_Laws's Profile: http://www.excelforum.com/member.php...o&userid=30012
View this thread: http://www.excelforum.com/showthread...hreadid=500357