Consulting

Results 1 to 4 of 4

Thread: How to add/copy Dynamic Named Ranges to Workbook

  1. #1
    VBAX Contributor
    Joined
    Oct 2013
    Posts
    181
    Location

    How to add/copy Dynamic Named Ranges to Workbook

    I need to know a couple of things, can VBA copy Dynamic Named Ranges to a list within a worksheet and then can the Dynamic Named Ranges be added to a workbook using VBA?

    I need to copy several lines of code similar to the one shown and add them another workbook?




    OFFSET(Lookup!$F$26,0,0,COUNTIF(Lookup!$F$26:$F$65539,">*"),1)
    Thank you for any and all help!

  2. #2
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,189
    Location
    I like your optimism oam, but what does this represent ">*"..... ???
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  3. #3
    VBAX Contributor
    Joined
    Oct 2013
    Posts
    181
    Location
    Aussiebear,

    Does "I like your optimism" mean VBA is not able to copy or add Dynamic Named Ranges? As far as ">*", I am not sure what this does but I have used this in the Named Ranges area to allow a Data Validation List to be adjusted without adjusting the Named Range.

  4. #4
    VBAX Contributor
    Joined
    Oct 2013
    Posts
    181
    Location
    modified a code I received from an earlier post from p45cal to allow me to add the Dynamic Named Range shown in this post.

    Thank you for your help p45cal

     ActiveWorkbook.Names.Add Name:=cll.Value, RefersTo:="=" & cll.Offset(, 2).Value

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •