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.
Have I specified range wrong?![]()
dim CurWs as Worksheet Dim Top() as Variant Top = Sheets(CurrentWs.Name).Range(Cells(7, 2), Sheets(CurrentWs.Name).Range(Cells(22, 3))).Value
Bookmarks