I wonder how do you have an array Series storing ranges.
If this was done without problem, i think you could apply the same method to
OverallSelectionRange.

I think it might be something like
Set OverallSelectionRange(2) = RangeTemp

keiji

"Tommy" wrote in message
...
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