Named Range - looping through each cell

Dear all, I have a named range TEST (B2:C3 and C5:D6) and I would like in VB loop though each cell in that range recording it's value whether it is a formula or value. I can dot hat with the following code but it requires cell's co-ordinates whereas in named range we have 2 sets of ranges and name is explicit.

  For Each c In Worksheets("sheet1").Range(Sheets("sheet1").Range(myarray(i, 3)), Sheets("sheet1").Range(myarray(i, 4))).Cells
        MsgBox myarray(i, 1) & "_" & k & " : " & myarray(i, 2) & " : " & c.Column & " : " & c.Row
        k = k + 1
        Next

thanks a lot!