I am trying to learn more about arrays and I am trying to set an array to a range of cells (B5:M12). I am getting an error in the following code.
Sub Macro3()Dim myArray() As Range, x, y As Integer
For x = 2 To 13
For y = 5 To 12
Set myArray(x, y) = Range(Cells(y, x))