CG Rosén wrote:
Is there another way to "split" the "result" -variable from the code below
into variables of type:


Dim R As Range
For Each R In Rng.Areas
MsgBox R.Address
Next


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup