I am trying to allocate an array with values from a worksheet in my workbook.

Sheet in question is a variable named CurWs and I have expected value in Watches window but this line of code throws me an error.

dim CurWs as Worksheet
Dim Top() as Variant

Top = Sheets(CurrentWs.Name).Range(Cells(7, 2), Sheets(CurrentWs.Name).Range(Cells(22, 3))).Value
Have I specified range wrong?