XLL+ Class Library (7.0)


Set the value of the referenced cells

BOOL SetValue(
   const CXlOper& xloValue
) const;



CXlOper containing the new value of the range referenced by this CXlOper. This can be an array.

Return Value

Returns TRUE if the function was successful, FALSE if it failed. The function can fail if the CXlOper does not contain a reference, or if it cannot be run in Excel at this time or if xloValue is not valid.


This function can only be called from macro functions. It will always fail if called from worksheet functions.

The function is extremely fast, particularly when compared to equivalent VBA methods. It is by far the fastest way to pump large amounts of data into Excel.


Header: xllplus.h

See Also

CXlOper Class | CXlOper Methods | CXlOper::Coerce() | CXlOper::GetActiveCell() | CXlOper::MakeRef()