Skip to Content
0
Former Member
Dec 04, 2009 at 03:37 AM

Switching Ranges

30 Views

was wondering if it was possible to switch data ranges based upon a selector e.g. radio button? I would like to have AnyMaps Region Keys point to a cell that has a formula that would evaluate based upon the position of the radio button control. Example something like the below -- which does not work.

IF(1,"Sheet1!$B$5:$B$66","Sheet1!$C$5:$C$66")

My goal would be to have a single AnyMap component display different data and region colors based upon the position of selector. My SVG map and image would remain be the same.

Thanks again!!!

/Greg