Can I use variables in a Range function?

  • Thread starter André - Brazil
  • Start date
A

André - Brazil

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
 
D

Duke Carey

You've DIMmed LINHAREF as an Integer, right?

Change it to: Lk = "K" & LINHAREF

Works for me.
 
D

Dave Peterson

You can also use cells().

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