VBA -使用Dim值获取范围-对象__global范围失败

Question

我有以下Dims

Dim PlayersStartAt As Integer
Dim PlayersEndAt As Integer
PlayersStartAt = 101
PlayersEndAt = PlayersStartAt + 50

Selection.AutoFill Destination:=Range("B & PlayersStartAt:B & PlayersEndAt"), Type:=xlFillDefault

，并希望执行以下代码行。

with great with Range("B101:B151");

我的语法有什么问题?

Answer 1

修改

Range("B & PlayersStartAt:B & PlayersEndAt")

Range("B" & PlayersStartAt & ":B" & PlayersEndAt)

PlayersStartAt和PlayersEndAt为变量。引号之间的任何内容都将作为字符串:)