Re: $$Excel-Macros$$ List of Dynamic & named ranges in workbook

> > http://tutorialway.com/use-named-range-in-excel/ > usse ful site -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thr

Re: $$Excel-Macros$$ List of Dynamic & named ranges in workbook

Hi Rajan, Here you go. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post

RE: $$Excel-Macros$$ List of Dynamic & named ranges in workbook

] On Behalf Of Kris Sent: Jan/Wed/2012 07:52 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ List of Dynamic & named ranges in workbook Hi Why VBA ?? In XL 2007, go to Formulas > Use in Formula > Paste Names In Xl 2003, Insert > Names > Paste Names

RE: $$Excel-Macros$$ List of Dynamic & named ranges in workbook

Hi Krishna.. Can you send the screenshot where this option is available in Excel.. Thanks Rajan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kris Sent: Jan/Wed/2012 07:52 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ List of

Re: $$Excel-Macros$$ List of Dynamic & named ranges in workbook

Hi Why VBA ?? In XL 2007, go to Formulas > Use in Formula > Paste Names In Xl 2003, Insert > Names > Paste Names Kris -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem

RE: $$Excel-Macros$$ List of Dynamic & named ranges in workbook

Try this: Sub listnames() Dim n As Name Dim i As Long i = 1 For Each n In ThisWorkbook.Names Range("E" & i) = n.Name Range("F" & i) = "'" & n.RefersToR1C1 i = i + 1 Next n End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of C

Re: $$Excel-Macros$$ List of Dynamic & named ranges in workbook

Dear Cab, Please use.. Sub listnames() Dim n As Name Dim i As Long i = 1 For Each n In ThisWorkbook.Names Range("E" & i) = n.Name Range("F" & i) = "'" & n.RefersToR1C1 i = i + 1 Next n End Sub -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*

Re: $$Excel-Macros$$ List of Dynamic & named ranges in workbook

Hi Noorain Works good now. Thanks. How do I get it to show also the range of cells in each name. e.g. List ASheet1 B.7:H50 Thanks Charlie On Wed, Jan 11, 2012 at 4:20 PM, NOORAIN ANSARI wrote: > Dear Cab, > > Please try t... > > Sub listnames() > Dim n As Name > Dim i As Long > > Fo

Re: $$Excel-Macros$$ List of Dynamic & named ranges in workbook

Dear Cab, Please try t... Sub listnames() Dim n As Name Dim i As Long For Each n In ThisWorkbook.Names i = i + 1 Range("E" & i) = n.Name Next n End Sub -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansar