TempActiveRef/TempActiveRef12
This content is outdated and is no longer being maintained. It is provided as a courtesy for individuals who are still using these technologies. This page may contain URLs that were valid when originally published, but now link to sites or pages that no longer exist.
Framework library function that creates a temporary XLOPER/XLOPER12 containing an external reference to rectangular block of cells on the active sheet.
LPXLOPER TempActiveRef(WORD rwFirst, WORD rwLast, BYTE colFirst, BYTE colLast);
LPXLOPER12 TempActiveRef12(ROW rwFirst, ROW rwLast, COL colFirst, COL colLast);
Parameters
rwFirst
The starting row of the reference.
rwLast
The ending row of the reference.
Row arguments are zero-based so that row 1 is passed as 0. In Microsoft Office Excel 2003 and earlier versions, and in Microsoft Office Excel 2007 running a workbook in compatibility mode, the maximum value is 65,535 = 2^16 - 1 and is the maximum value that can be taken by a WORD integer. In Excel 2007 running a 2007 format workbook, the maximum value is 1,048,575 = 2^20 - 1. RW is defined as a 32-bit signed integer in XLCALL.H.
colFirst
The starting column number of the reference.
colLast
The ending column number of the reference.
Column arguments are zero-based so that column A is passed as 0. In Excel 2003 and earlier versions, and in Excel 2007 running a workbook in compatibility mode, the maximum value is 255 = 2^8 - 1 and is the maximum value that can be taken by a BYTE integer. In Excel 2007 running a 2007 format workbook, the maximum value is 16,383 = 2^14 - 1. COL is defined as a 32-bit signed integer in XLCALL.H.
Return Value
Returns an xltypeRef external reference to rectangular block of cells passed in.
Example
This example uses the TempActiveRef12 function to select cells A105:C110.
\SAMPLES\EXAMPLE\EXAMPLE.C
short WINAPI TempActiveRefExample(void)
{
Excel12f(xlcSelect, 0, 1, TempActiveRef12(104, 109, 0, 2));
return 1;
}