Cells in VBA

[elotromateo]

Is there a function that gives the cell number in VBA?

I don't want Cells or Range which give the value inside the cell, but the location of the cell itself. I am trying to create a While statement and I would prefer to do it without a For statement.

 

[JackDanIce]

Run this code and see if it's helps with your query:

Sub testme()
Dim i As Integer
i = 5
MsgBox Range("A" & i).Address
End Sub