Changing a String to a Range

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!

Example:
Union(Range("A1:B2"), Range("C7:D8"))
--
HTH,
Gary Brown
[email protected]
If this post was helpful to you, please select ''YES'' at the bottom of the
post.



"[email protected]" 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!
>
>