Convert Text string to Array Formula

[Steve Schlesinger]

I have numerical data in A1:A10

B1 has a string "A2:A6"

I want to convert the string to an array formula so that
=SUM( some forumla with B1 ) returns the same as
=SUM( A2:A6 )

A solution with VBA is OK.

Thanks-
Steve AT Schlesinger DOT com