I'm trying to create a graph that has a range that will be dependant on a selectable drop down. I've managed to specify what the range will be through a combination of the match function and concatenates. The Dynamic range therefore exists in a control sheet cell as text. I then use the indirect function in the Range specifier for the Graph.

The problem is that when I input my dynamic Indirect range into the Range box in the graph box the next time I look at the range it's become fixed.

Is there any way around this?

My initial thoughts are to include a refresh button that will run some VBS code that will paste the Indirect code into the Range specification box.

Am I going in the right direction?

I running this in 97 and the Range will not be composed of a fixed amount of rows or columns.

Many Thanks