Convert Text string to Array Formula

  • Thread starter Steve Schlesinger
  • Start date
S

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula Query 9
Convert text into formula. 7
Array reference 3
Remove certain characters from a text string 6
ISODD array formula 1
Macro to add Multiple rows in same sheet 1
Is there an array formula that works with text? 3
Dynamic Sum Array Formula Input Help 3

Top