Assigning a range to an array

[brucemc777]

WHY does

Dim arStudents() As Variant
Worksheets("George").Select
arStudents = Range("B2:B17")

work, but

Dim arStudents() As Variant

arStudents = Worksheets("George").Range("B2:B17")

does not???

THANK-YOU ALL for your continuing help!

[romperstomper]

Due to the level of indirection, you either need:

arStudents = Worksheets("George").Range("B2:B17").Value

or:

Dim arStudents as Variant

You should always specify .Value or .Value2 anyway.

[brucemc777]

Thank-you!