VBA Excel : Sheet Named range into Array

The below code will be used to access the list of named-range values and pass to an array variable.