Ranges in selection and arrays

Hi everyone,

I have this following code i need help with

Please Login or Register  to view this content.

The code is unfinished because i don't know how to convert the first range selection (ex: A to E would be 1 to 5) and store it for later use. I would also want to store the cell range(i, j) of the second selection in another array.

Here's the code i will use with the arrays

Please Login or Register  to view this content.

Thanks in advance.

Let me see if i can make this a bit clear.

I'm trying to store a user selection of ranges and cells into arrays so i can process those selections through the calculations i've already made.

Suppose user wants to anaylse 3 columns and he selects the range for the first table and the cell of that first table, the macro will store the value of the row to start in and the cell values. I need help making this to happen.

With that values stored the analyses will take place (the second macro i've made), the problem is i've based the second script on fixed cell values so i want to take the values from the array and use them.

I've attached an example of the worksheet. In this example if user selects K5, Z5 and AO5 i want the second macro to run K5 against Z5 and K5 against AO5.

I hope i've made my point a bit clear.

13081715551.xlsx

Here's what i wrote so far.

Please Login or Register  to view this content.

The problem is i get the subscript out of range error when i try to store the cell row and columns in cArray().

It fails on the first loop in this step

Please Login or Register  to view this content.

I've also deleted ReDim rArray(0)

Thank you, so based on that i've set

Please Login or Register  to view this content.

Now the rArray is storing the values correctly the problem is the cArray

Please Login or Register  to view this content.

I couldn't make it work with that commands but i managed to get a workaround.

If you could help me with my other problem anaylising multiple cells at the same time, i would be appreciated.

Here's what i mean from the code i have.

Please Login or Register  to view this content.

Variable a and d will be the fixed from the first selected cell.
Variable b and c will have values from the other selected cells which i want to compare against a and d.
If you have 3 selected cells the comparision i want is cell 1 vs cell 2 and cell 1 vs cell 3 all at the same time so that the line that will be inserted will be equally distribuited.

Thanks for your patience.