Create a new worksheet and go to Insert Name Paste. Click on "Paste All."

HTH
Jason
Atlanta, GA

"yrk" wrote:

I got a spread sheet from some one else. There were formulas used using names.
I like to retrieve the values used for different names used in the formulas.

Please let me know for any questions.

Rao