Changing a String to a Range

[schorley]

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!

 

[Guest]

Example:
Union(Range("A1:B2"), Range("C78"))
--
HTH,
Gary Brown
(e-mail address removed)
If this post was helpful to you, please select ''YES'' at the bottom of the
post.