TempActiveColumn/TempActiveColumn12

Applies to: Excel 2013 | Office 2013 | Visual Studio

Framework library functions that create a temporary XLOPER/ XLOPER12 containing an external reference to an entire column on the active sheet.

LPXLOPER TempActiveColumn(BYTE col);
LPXLOPER12 TempActiveColumn12(COL col);

Parameters

col (BYTE)

The column to be referenced. This is zero-based so that column A is passed as 0. In Microsoft Office Excel 2003 and earlier versions, and starting 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. Starting in Excel 2007 running a 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 the column passed in.

Example

The following example uses TempActiveColumn12 to select the entire column B.

\SAMPLES\EXAMPLE\EXAMPLE.C

short WINAPI TempActiveColumnExample(void)
{
    Excel12f(xlcSelect, 0, 1, TempActiveColumn12(1));
    return 1;
}

See also

Functions in the Framework Library