I have created a command button that plays the following macro.
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.
Bookmarks