Arrays - Redim Preserve

The concept eventually is to load data into an array from multiple worksheets, and output the duplicates into a new sheet.

I'm loading the data into the array as dynamic ranges - I'll load from the first sheet, then Redim Preserve the array based on the last used row of the next sheet to be loaded in.

I'm struggling with the Redim Preserve element as it's giving me a subscript out of range error.

Please Login or Register  to view this content.

Other examples I've researched appear to follow this but I can't get it to work - where am I going wrong?

Thanks - I should have realised this after the amount of reading I did before posting.

My plan was to load several worksheets into an array to find duplicates and return the worksheet names where the duplicates appear, however I'll stick to looping through worksheets for now, until I have some time to do more research into arrays.

Thanks for the help.