+ Reply to Thread
Results 1 to 1 of 1

Multiple named ranges with variable lengths set by user via single cell value

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2003

    Multiple named ranges with variable lengths set by user via single cell value

    I have a column of data which I need grouped into named ranges. However, I need to group the data in variable length groups. For example, I might have a column of 30 numbers (E1 to E31) and I want to group them in groups of 10 or 15. I set a cell I6 to have the grouping value. Having searched everywhere and having very limited vb experience, I tried the the code listed below. One might be able to see what I'm trying to do. Is there a way to pass the values of the variables "name" and "j" to the named range command? Row a is a list of names such as "test1", "test2", "test3"... I would rather just do test(j) in the name section of the named range command. Thanks in advance for any help.

    Please Login or Register  to view this content.

    Moderator Edit:

    Welcome to the forum, devcow.

    Please notice that [CODE] tags have been added to your post. The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at the top of the page and read Rule #3.
    Last edited by Cutter; 10-17-2012 at 04:47 PM. Reason: Added code tags

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread


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