Hi guys,

I have two ranges which are stored in an array, Series(1) and
Series(2). I then create a union range:

Set RangeTemp = Application.Union(Series(1), Series(2))

'''So now, RangeTemp holds my range.

'''To check that the range selects ok:

RangeTemp.Select

'''' I also defined:

Dim OverallSelectionRange(1 To 6) As Variant

OverallSelectionRange(2) = RangeTemp

OverallSelectionRange(2).Select <-- This line gives me the error:
'Object Required'


As you can see, I want to assign the range stored in RangeTemp to the
second OverallSelectionRange array element. That line works, but then
the last line gives me the Object Required error. Why is this?? Surely
I am simple assigning a range into that element of the array? Why
doesn't this work?

Regards and thanks,

Tom