I have a worksheet with a bunch of named ranges in it and am having trouble selecting these ranges via:
For i = 1 To activeworkbook.Names.Count
The only way this works is if the sheet that the range refers to is active. This defeats the purpose of the named range! Otherwise I get "Run time error '1004' - Select method of range failed".
This is killing me because I can see the sheet name in the 'refersto', and could parse it out and activate it, but this seems wrong. I have played with using .value, .refersto, .name, but none work. But I would like to access these ranges regadless of what sheet is currentlty active.