I need to do something like this
I don't want to use Cells(i, 1) all the time.![]()
Sub Display() For i = 1 To 5 If Cells(i, 1).Value = "" Then Exit For MsgBox (Cells(i, 1).Address & "=" & Cells(i, 1).Value) Next i End Sub
Instead I would like to use something like
and then to use cell instead Cells(1,1).![]()
cell = Cells(i, 1)
Bookmarks