Range.Select method Archives

Learn

Select a Range with Excel VBA

This course will show you how to use Range, Cells, Offset, Resize and Union to select a range in Excel VBA. Take this free course now!

Learn

Excel Macro: Highlight the Active Row and Column

The VBA code examples show ways to highlight the active cell or the rows and columns that contain the active cell. Get the VBA code now!

Range.Column property Range.CurrentRegion property Range.Select method Range.EntireColumn property Range.EntireRow property IsEmpty function Worksheet.SelectionChange event Worksheet.BeforeDoubleClick event Application.ScreenUpdating property Interior.ColorIndex property Range.Interior property Range.Address property On Error statement

Docs

Range.Select method

Selects the object. Syntax expression.Select expression A variable that represents a Range object. Return value Variant Remarks To select a cell or […]

Range.Select method

Learn

Reference cells and ranges

Programming with Excel VBA: The method of reference cells and ranges. Take this free course now!

Range.ClearHyperlinks method Range.ClearContents method Range.ClearComments method Range.Clear method Range.ClearFormats method Range.Resize property Range.Count property Range.Offset property Range.Select method Range.Address property For...Next statement With statement