Example:
Union(Range("A1:B2"), Range("C7:D8"))
--
HTH,
Gary Brown

If this post was helpful to you, please select ''YES'' at the bottom of the
post.



" wrote:

Hi

Basically, I just want to know if there is any (easy) way of changing a
string (as in, a cell in Excel contains a 3D cell range as text) to the
appropriate range.

So, in cell K12 I have the following text :
'Quarter 1 Contract 03'!C12,'Quarter 1 Spot 03'!C12,'Quarter 2 Contract
03'!C12,'Quarter 2 Spot 03'!C12,'Quarter 3 Contract 03'!C12,'Quarter 4
Contract 03'!C12,'Quarter 4 Spot 03'!C12

And I want to change this to a range in VBA so I can COUNTIF (cells <
0)!

If I havent explained properly, say and I'll try harder!

Thanks!