IXlsDynamicRange

COM interface ( getting help with interfaces )

interface IXlsDynamicRange : IDispatch
{
    [id(1), propget] HRESULT Name([out, retval] BSTR* name);
    [id(2), propget] HRESULT Formula([out, retval] BSTR* formula);
    [id(2), propput] HRESULT Formula([in] BSTR formula);
    [id(3), propget] HRESULT Hidden([out, retval]BOOL* hidden);
    [id(3), propput] HRESULT Hidden([in]BOOL hidden);
    [id(4)         ] HRESULT Delete();
    [id(5), propput] HRESULT BuiltInNamedRange([in]enumBuiltInNamedRange type);
    [id(6), propget] HRESULT Worksheet([out, retval]BSTR* worksheetname);
    [id(7), propget] HRESULT IsTable([out, retval]BOOL* isTable);

}

HRESULT Name([out, retval] BSTR* name);
retrieves the name of the dynamic range.

HRESULT Formula([out, retval] BSTR* formula);
retrieves the associated formula of the dynamic range.

HRESULT Formula([in] BSTR formula);
defines the formula of the dynamic range.

HRESULT Hidden([out, retval]BOOL* hidden);
returns whether the dynamic range should be hidden.

HRESULT Hidden([in]BOOL hidden);
sets whether the dynamic range should be hidden.

HRESULT Delete();
deletes the dynamic range.

HRESULT BuiltInNamedRange([in]enumBuiltInNamedRange type);
sets the built-in named range type, in case this named range must achieve a particular effect (print area, database, ...).

HRESULT Worksheet([out, retval]BSTR* worksheetname);
retrieves the worksheet name hosting the dynamic range if the dynamic range has a local scope, or an empty string otherwise.

HRESULT IsTable([out, retval]BOOL* isTable);
returns whether the dynamic range represents a table.