Column numbers in Excel are denoted by letters (A, B, C, etc.). COLUMN function returns the column number of the active cell. Function can be used with cell references to find specific column numbers. COLUMN(range) returns column numbers as a horizontal array. COLUMNS function returns the number of columns in an array
VBA cells reference cells in worksheets for automation tasks. Cells property is a property, Range object is an object. Cells reference uses R1C1 format with row and column numbers
VBA code must be placed in the VB Editor. Single cells can be selected using Range("A1"). Fixed-sized ranges can be selected using top-left and bottom-right addresses. Variable-sized ranges require CurrentRange or End property
Active cell is currently selected cell for entering text or formulas. Only one active cell exists even with multiple selected cells. Active cell appears lighter in color and shows cell reference in Name box
Paste Special allows selective copying of cell properties using CTRL+ALT+V. Paste Values copies only cell value, including formula results. Paste Formats copies all cell formatting. Paste Formulas copies only cell formulas
RANGE object's ROWS property and COUNT property are used to count rows. Example shows counting rows from A1 to A8 range