Multiple Range variables inside an only Range array

Hello !

First of all, I'm not sure of the term "array". But when I was doing VB I often did this :

Please Login or Register  to view this content.

What I would like to know is if you can do the same in Excel + VBA by having a different range for e.g. range(1), range(2), range(7)...

I want to do this because I want to check a list and pick a related range in particular each time this list has a certain value...

Thank you all !

The workbook is pretty much empty at the moment... To try my code, I randomly put "1" or "2" in the cells A1 to A20. What I want my code to do is checking each line and if its content in column A is a "1", the 4 first cells of this line go to a Range variable. For example, A5 contains "1", I want something like RangeName(5) = Range("A5") (which does not work...).

Sorry for not giving the WB, but it would have not helped at all, trust me !