通过 VBA 选择 Range 类的方法失败

问题描述

这是我目前正在使用的代码，我遇到了这个问题.我是 Excel 新手，不知道出了什么问题.

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

错误是Range类的Select方法通过VBA失败，错误1004.有什么想法吗?

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

预计到达时间:

所以我只是把代码改成

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

我相信这就是您所说的让它活跃的意思吗?

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

但是我仍然遇到对象_Worksheet"的方法范围"失败，错误1004.

推荐答案

我相信你有 同样的问题在这里.
工作表必须处于活动状态，您才能在其上选择范围.

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

或者，

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

这是一样的.

这篇关于通过 VBA 选择 Range 类的方法失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！