Run formula on different named ranges

[hjsinger]

Hi,
I have a large number of named ranges and I want to run the same formula on all of them.
It seems like I should be able to make a list of the named ranges and then run the formula on all of them but I can't get it to work...anyone? Thanks in advance.

JFS

 

[kweaver]

Insert a new sheet. While on that sheet, from the formula tab on the ribbon, click on Use in Formula in the Named Range group. Then, from the drop down, Paste Names... and then Paste List.

You can then loop through those rows and apply your formulas.

Does this do it for you?