Hi all,

I'm having difficulty understanding why some code created by the Macro
Recorder will not work for a Command Button Click Event.

To illustrate the problem, I created the following macro (in Excel
2000):

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 4/4/2006 by Teodomiro
'

'
Sheets("Sheet2").Select
Range("A1:B20").Select
End Sub

Running it as a macro, it works fine. But when I create a Command
Button, and copy the code into it's Click event, I get:

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

I'm just trying to select a range on a different sheet. Can anyone
explain what's going on here?


--
Teodomiro


------------------------------------------------------------------------
Teodomiro's Profile: http://www.excelforum.com/member.php...o&userid=33140
View this thread: http://www.excelforum.com/showthread...hreadid=529515