Range selection problem when called from a button.

[amd62]

I have a button on a worksheet which performs certain functions on the active worksheet.
It then performs functions on another worksheet within the same workbook.
It's at this point that I encounter Error 1004, "Select method of Range class failed."

Sample:
ThisWorkbook.Sheets("Sheet2").Activate
Range("A1").Select

Even if I refer to the range explicitly, the error persists.
Sample:
ThisWorkbook.Sheets("Sheet2").Range("A1").Select

This problem does not occur when run under Kingsoft.

[Olly]

Sounds like the sheet name is wrong.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[Norie]

Try this.

Application.Goto ThisWorkbook.Sheets("Sheet2").Range("A1")

[amd62]

Thanks for your reply - much appreciated!
Unfortunately, Application.Goto ThisWorkbook.Sheets("Sheet2").Range("A1") produces the same error.
Perhaps I need a work around? Button loads worksheet and sets general variable. On loading the page and checking general variable, function executed or ignored?