This project has moved and is read-only. For the latest updates, please go here.

How to retrieve value of a named range

Apr 14, 2014 at 10:10 PM
Edited Apr 14, 2014 at 10:11 PM
workbook.names or sheet.names will give a list of names. How to get the Range that represents a named range?
Once I get the range, I can get its value. thanks
Apr 17, 2014 at 10:20 PM
Oh, I got it.

name.RefersToRange will give me the range a named cell refers

Marked as answer by toosensitive on 4/17/2014 at 2:20 PM