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.
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.