I have names listed in sheet1 A1:A11
Tom
Scott
Paul
Joe
Bruce
Joy
Daniel
Ruth
Tim
Dan
Mike
Is there any way to make them into and array like this, without having to type the names again? Or can you use a sheet reference in an array? Real data has more names
MyNames = Array("Tom", "Scott", "Paul", "Joe", _
"Bruce", "Joy", "Daniel", "Ruth", "Tim", _
"Dan", "Mike")
Tom
Scott
Paul
Joe
Bruce
Joy
Daniel
Ruth
Tim
Dan
Mike
Is there any way to make them into and array like this, without having to type the names again? Or can you use a sheet reference in an array? Real data has more names
MyNames = Array("Tom", "Scott", "Paul", "Joe", _
"Bruce", "Joy", "Daniel", "Ruth", "Tim", _
"Dan", "Mike")