Reputation: 3450
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?
Range("C200")
A
i
Upvotes: 1
Views: 40
Reputation: 2548
You should use
Range(A+Cstr(i))
Reputation: 580
should be
Range(str & "200")