Hello,
I'm working on a macro to let the user select a number of cell ranges (of equal size) from different sheets to consolidate all ranges into one.

Eg:
Please Login or Register  to view this content.
I recorded a macro to consolidate the cell ranges, but I can't quite figure out how to write the code so that the macro will use the selected ranges..

Code from macro recording (just consolidate):
Please Login or Register  to view this content.
I tried to modify the macro to use entered cell ranges:
Please Login or Register  to view this content.
Am I doing something wrong when the Array is formed?
I made the changed text bold in the consolidate function in the code above.
The error message says "non-valid reference"

Thanks in advance!

/bleck