Range.End property Archives - ExcelBaby

Learn

Excel Macro: Sort Column Data By Double Clicking Header Cell

If you want to sort the column data in ascending or descending order by double clicking on any Excel column header, you […]

Range.Sort method Range.Row property Range.Count property Range.End property IsEmpty function Worksheet.BeforeDoubleClick event Exit statement If...Then...Else statement

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

Docs

Range.End property

Returns a Range object that represents the cell at the end of the region that contains the source range. Equivalent to pressing […]

Range.End property