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);
}

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, ...).