Can I use variables in a Range function?

[Guest]

I´m triyng to use a variable content in a Range function without success,
Example:

LINHAREF = 10
Do While LINHAREF < 40
Lk = "K" + Str(LINHAREF)
MsgBox Range(Lk)
LINHAREF = LINHAREF +1
Loop

 

[Guest]

You've DIMmed LINHAREF as an Integer, right?

Change it to: Lk = "K" & LINHAREF

Works for me.

 

[Dave Peterson]

You can also use cells().

LINHAREF = 10
Do While LINHAREF < 40
MsgBox cells(linharef,"K").value
LINHAREF = LINHAREF +1
Loop