PDA

View Full Version : Solved: Named Ranges



MaayanSV
02-02-2012, 05:16 AM
Hello All,

Is there a possibility to capture all named ranges and its values using VBA ?:banghead:

Regards,
Maayan

Bob Phillips
02-02-2012, 05:53 AM
For Each nme In Thisworkbook.Names

Debug.Print nme.Name & " - " & nme.RefersTo
Next nme

MaayanSV
02-02-2012, 06:50 AM
Thank you