Tag Archives: range names

Displaying range names

Posted on 28/04/2014 by dougaj4

A useful tip, brought to you from Bob Umlas, via Mike Alexander: If you want to display the named ranges in a spreadsheet, one way is to open the Name Manager (from the Formulas ribbon).  Another is to press F3, … Continue reading →

Posted in Excel | Tagged , , | 1 Comment

Finding all range names in a specified range

Posted on 24/01/2011 by dougaj4

Another useful little snippet from Eng-tips. There was a question regarding how to list all the range names applied to a specified cell.  Forum members electricpete and MintJulep came up with a short macro to do the job, which I have … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , | 2 Comments