OBJECT

See Also

Returns information from an object returned to the spreadsheet.

Syntax

OBJECT(range)

Range   is a reference to a range object returned by a function such as CREATEOBJECT. It can be a nested function or a cell reference.

Example

Note   The example shown uses a fictional ProgID and ServerName.

	A	Description (Result)
1	=CREATEOBJECT("msn.marketdata", "\\investor")	Returns IDispatch object for stock data from the investor server.
2	=OBJECT($A$1).LastPrice("MSFT")	Returns last price of stock from information contained in object returned in cell A1.