Stupid_Intern
Stupid_Intern

Reputation: 3450

Range using character variable

I have following variables

Dim A,i
A="C"
i=200

I want to construct Range("C200") using variable A and i from above, how to do this?

Upvotes: 1

Views: 40

Answers (2)

Prokurors
Prokurors

Reputation: 2548

You should use

Range(A+Cstr(i))

Upvotes: 1

neuralgroove
neuralgroove

Reputation: 580

should be

 Range(str & "200")

Upvotes: 1

Related Questions