selected cell range when chart is selected

[bmurphy]

When an on-sheet chart is currently selected, is it possible to determine the currently selected range of worksheet cells? These cells could be any cells and not related to the chart.

From the user interface, if I hit escape a few times, this deselects the chart and the selected cell range becomes the "Selection". But how does one deselect a chart to get at the selected cell range?

The excel 2003 macro recorder simply records
ActiveWindow.Visible = False
But that does not reproduce the action of deselecting the chart.

Thanks,
Brian

 

[bmurphy]

Re: selected cell range when chart is selected - solved

ActiveWindow.RangeSelection
This is the answer. I stumbled across it in a j-walk book. Thanks, John.