I read a range on a worksheet and put it into an array.
Dim Arr() As Variant
Arr = Range("B3:G11")
Dim R As Long
Dim C As Long
For R = 1 To UBound(Arr, 1)
For C = 1 To UBound(Arr, 2)
Debug.Print Arr(R, C)
Next C
Next R
This returns the value of the cell. Is there a way to get the address of the cell?!
Thank you in advance.