+ Reply to Thread
Results 1 to 3 of 3

Dynamic Names with Dynamic Range

  1. #1
    Forum Contributor
    Join Date
    11-10-2012
    Location
    istanbul
    MS-Off Ver
    Excel 2013
    Posts
    297

    Dynamic Names with Dynamic Range

    I have the below code:
    Please Login or Register  to view this content.
    With this code I can create names which Sheet2 From A column To F column one by one.
    A:F columns and its rows are dynamic.Sometimes column goes to M or N some times back to D or E.
    And at the same time For each column there are differrent rows number.(Ex. A column has 5 rows, B 3 rows, C 18 rows... and so on)

    How can I modify the code, for all columns which exist in Sheet2 and differrent rows ?
    I thought" for next" , "with range" or "loop" statements, but couldn't find a way.

    Thanks in advance for any reply and help.

    Best regards,
    turist

  2. #2
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: Dynamic Names with Dynamic Range

    The second point is already covered by your existing code, but try this:
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    11-10-2012
    Location
    istanbul
    MS-Off Ver
    Excel 2013
    Posts
    297

    Re: Dynamic Names with Dynamic Range

    Great. Works very well.
    Thanks a lot.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 10
    Last Post: 10-09-2014, 06:20 PM
  2. [SOLVED] Dynamic Range Names
    By dreicer_Jarr in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-28-2013, 10:20 PM
  3. Dynamic range names
    By icegood in forum Excel General
    Replies: 2
    Last Post: 02-23-2011, 12:30 PM
  4. [SOLVED] dynamic range names in Edit -> Go to
    By Tim Marsh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-23-2006, 08:50 AM
  5. Dynamic Range Names For a Graph
    By whiZZfiZZ in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-16-2006, 01:45 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1