I'm trying to read unique values from an Excel 2007 named range into a VBA array, I've figured out how to do this when reading from an access DB table but that's not an option here.
If I have a named range on Sheet1 in cells A1..A6 called Fruit
and Fruit contains:
the array should contain:
Apples, Oranges, Peaches, Kiwi
Any help would be greatly appreciated.