VBA - get range using Dim values - range of object __global failed

Question

I have the following Dims

Dim PlayersStartAt As Integer
Dim PlayersEndAt As Integer

PlayersStartAt = 101
PlayersEndAt = PlayersStartAt + 50


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

and want to execute the following line of code.

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

What is wrong with my syntax?

Siddharth Rout · Accepted Answer · 2013-04-19 01:04:09Z

3

Change this

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

to

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

PlayersStartAt and PlayersEndAt are variables. Anything that you put between quotes will be taken as a string :)

answered Apr 19, 2013 at 1:04

Siddharth Rout

150k18 gold badges212 silver badges258 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

VBA - get range using Dim values - range of object __global failed

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related