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:
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):
I tried to modify the macro to use entered cell ranges:
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
Bookmarks