I have a snippet of code below which will assign a range to an array, all works well:
Dim rngAB As Range
Dim arr() As Variant
Set rngAB = wsWeights.Range("AB4:AB" & wsWeights.Cells(Rows.count, "AB").End(xlUp).Row)
arr = rngAB
However, when they result of the .End(xlUP).row is 4 which makes...