View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chimanrao Chimanrao is offline
external usenet poster
 
Posts: 19
Default type of selection if selection is chart

this is what msdn says

"The returned object type depends on the current selection (for
example, if a cell is selected, this property returns a Range object).
The Selection property returns Nothing if nothing is selected."

What is the type of selection object if a chart is selected?

I am using C++ and COM.

IDispatch *pDispatch = m_Application-GetSelection();
if (pDispatch == NULL)
return ;

CComQIPtr<MSExcel::Range ranges(pDispatch);
if (ranges == NULL)
return ;

If the user selects a chart the ranges object is null, I tried querying
for _Chart, even that is null.