Need help in setting boundaries in excel VBA (or is it called setting arrays?)

Hi all,


for example there is a number in Cell A1, then another number in Cell A4, Another number in Cell A10. How do i set boundaries in a way that Starting from Cell A1 up to cell A3, all rows are Boundary1, and all rows from Cell A4 to cell A9 is another boundary, and so on? I have an idea how to do it but i dont know the exact command. Something like excel will examine each cell in column A:A, and if it reaches cell A1, and then A4, the macro will declare entire rows of A1:A3 the first boundary, and after going through A4 and it detects another number in cell A10, excel will declare all the rows from A4 to A10 as the other boundary. How can this be done? I am very sorry im not good with arrays

bump, anyone?