Run Time Error 1004 when selecting range on another sheet using a command button

**randolphoralph** · 11-20-2009, 04:01 PM

I have created a command button that plays the following macro.

Code:

Private Sub CommandButton1_Click()
    Sheets("Sheet2").Select
    Range("B10:C19").Select
End Sub

The command button is on Sheet1 and when I click the command button and the macro plays it will select Sheet2 and the range B10:C19, and returns a Run Time Error '1004': Select method of Range class failed.

I have tried to play the macro without using the command button and it will select the range from Sheet2 without any problems/errors. I change the macro to select the range on Sheet1 and it works fine. I know the issue has something to do with the command button and can not figure it out.

I am not sure what I am missing. Any help would be greatly appreciated.

**Chance2** · 11-20-2009, 04:49 PM

Just add the sheet reference to the range...

Code:

Private Sub CommandButton1_Click()
    Sheets("Sheet2").Select
    Sheets("Sheet2").Range("B10:C19").Select
End Sub

The code is executing from Sheet1, so when Sheet2 is selected it is trying to select the range on Sheet1 (the Macro is not tied to the sheet, so that's why it works).

**randolphoralph** · 11-20-2009, 05:01 PM

It worked! Thank you so much

Thread: Run Time Error 1004 when selecting range on another sheet using a command button

Thread Tools

Display

Run Time Error 1004 when selecting range on another sheet using a command button

Re: Run Time Error 1004 when selecting range on another sheet using a command button

Re: Run Time Error 1004 when selecting range on another sheet using a command button

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions