Hi Guys, thanks for your reply. i wanted macro for this. from the code generated i tried this selection.listanames but it gives values as " =Sheet1!$F$4:$F$7 "
so i will have to remove this = sign using replace or is there any way where i will get same data without = sign. also, just for the sake of curiosity how can i change this staic range into dynamic range i.e. from Sheet1!$F$4:$F$7 to Sheet1!F4:F7 ________________________________ From: §»VIPER«§ <viper....@gmail.com> To: excel-macros@googlegroups.com Sent: Sat, 19 March, 2011 2:10:26 PM Subject: Re: $$Excel-Macros$$ Find all NamedRanges in Worksheet/workbook hi ashish the same will work in 2003 -- Thanks & Regards Thamu On Sat, Mar 19, 2011 at 1:56 PM, ashish koul <koul.ash...@gmail.com> wrote: try this (excel 2007) i haven't tested it on 2003 > > >press f3 and click on paste list > > > > > > >On Fri, Mar 18, 2011 at 10:27 PM, hanumant shinde <hanumant_5...@yahoo.co.in> >wrote: > >Hi friends, >> >>i want to find out all the namedranges from worksheet / workbook. can >>somebody >>please help me. >> >>eg. lets say A1 to A4 name of the range is range1 >>lets say B1 to B4 name of the range is range2 >>lets say C1 to C4 name of the range is range3 >>lets say D1 to D4 name of the range is range4 >> >>NamedRange may have any name and it wil refer to any range. there is no fix >>format. >>looking for reply >>-- >>---------------------------------------------------------------------------------- >> >>Some important links for excel users: >>1. Follow us on TWITTER for tips tricks and links : >>http://twitter.com/exceldailytip >>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>3. Excel tutorials at http://www.excel-macros.blogspot.com >>4. Learn VBA Macros at http://www.quickvba.blogspot.com >>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >>To post to this group, send email to excel-macros@googlegroups.com >> >><><><><><><><><><><><><><><><><><><><><><><> >>Like our page on facebook , Just follow below link >>http://www.facebook.com/discussexcel >> > > >-- > >Regards > >Ashish Koul >akoul.blogspot.com >akoul.wordpress.com >My Linkedin Profile > >PBefore printing, think about the environment. > >-- >---------------------------------------------------------------------------------- > >Some important links for excel users: >1. Follow us on TWITTER for tips tricks and links : >http://twitter.com/exceldailytip >2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >3. Excel tutorials at http://www.excel-macros.blogspot.com >4. Learn VBA Macros at http://www.quickvba.blogspot.com >5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > >To post to this group, send email to excel-macros@googlegroups.com > ><><><><><><><><><><><><><><><><><><><><><><> >Like our page on facebook , Just follow below link >http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
