Range.CurrentRegion property Archives - ExcelBaby

Learn

Go To Special with VBA

You can use Excel VBA to quickly find and select all cells that contain a specific type of data, just like using the Go To Specials command.

Range.Dependents property Range.DirectDependents property Range.DirectPrecedents property Range.Precedents property Range.ColumnDifferences method Range.RowDifferences method XlCellType enumeration Range.SpecialCells method Range.CurrentRegion property

Learn

Excel Macro: Loop Through a List of Data

When you write a VBA Macro, you may have to loop through a list of data on a worksheet, this is one of VBA's must-have skills. Get it now!

Worksheet.UsedRange property Range.Count property Range.End property Range.CurrentRegion property Font.Bold property For Each...Next statement If...Then...Else statement

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!

Worksheet.UsedRange property Range.Resize property Range.Count property Range.Offset property Application.Goto method Range.End property Range.CurrentRegion property Range.Select method Application.Union method

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.CurrentRegion property

Returns a Range object that represents the current region. The current region is a range bounded by any combination of blank rows […]

Range.CurrentRegion property