<< Return to Main Index

< Return to Class Index

CGXFormulaSheet::GetRangeNameArray

BOOL GetRangeNameArray(CStringArray& array) const;

array

String array with all named ranges to be added.

Return Value

TRUE if ranges could be successfully added. FALSE if ranges were invalid.

Remarks

Returns a string array with all named ranges. Each entry in the array is in the form 'name=A1..B5'

Example:


   pGrid->GetSheetContext()->GetRangeNameArray(m_strRangeArray);
   for (int i = 0; i < m_strRangeArray.GetSize(); i++)
      m_cbNamedRanges.AddString(m_strRangeArray[i]);

CGXFormulaSheet