Select method of Range class failed via VBA

Question

This is the code that I'm currently working with, and I'm getting this problem. I'm novice at Excel and I can't figure out what's wrong.

Private Sub cmdRecord_Click() Sheets("BxWsn Simulation").Range("Result").Select //This is the line with the problem, as excel told me.     Selection.Copy     Sheets("Reslt Record").Select     Sheets("Reslt Record").Range("A5000").End(xlUp).Offset(1).Select     Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _         xlNone, SkipBlanks:=False, Transpose:=False     Sheets("CuCon Simulator").Select     Application.CutCopyMode = False     Range("Improvement").Select End Sub 

The error is Select method of Range class failed via VBA, Error 1004. Any ideas?

ETA:

So I just changed the code to

Sheets("BxWsn Simulation").Select Range("Result").Select 

I believe this is what you mean by making it active?

However I'm still getting Method 'Range' of object '_Worksheet' failed, error 1004.

Answer 1

I believe you are having the same problem here.
The sheet must be active before you can select a range on it.

Also, don't omit the sheet name qualifier:

Sheets("BxWsn Simulation").Select Sheets("BxWsn Simulation").Range("Result").Select 

Or,

With Sheets("BxWsn Simulation")   .Select   .Range("Result").Select End WIth 

which is the same.