I just tested with a regular button/shape and it worked just fine. I do NOT
like using the command buttons. Look at the forms tools for your button.

--
Don Guillett
SalesAid Software

"Fernando Ortiz" wrote in message
...
Hi Excel Experts:

I am working on a macro and find this

The CommandButton1 is in the sheet1 and when click on it, the code failed
and error 1004 apears

I dont't understand why.

This code is on the sheets1

Private Sub CommandButton1_Click()
Sheets(2).Select
RowEmpty = Range("A1").CurrentRegion.Rows.Count + 1
Cells(RowEmpty, 1).Select
End Sub

Thanks a lot for any advice.

Regards,


Fernando Ortiz