Range.Count property Archives

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 […]

Learn

Excel Macro: Delete Blank or Empty Columns

Blank columns can often cause problems with formulas. this macro can help automate delete blank columns. Get this VBA code now!

WorksheetFunction.CountA method Range.Delete method Worksheet.UsedRange property Range.Count property Range.EntireColumn property For...Next statement

Learn

Excel Macro: Delete Blank or Empty Rows

Blank rows can often cause problems with formulas. This macro can help automate delete blank or empty rows. Get this VBA code now!

WorksheetFunction.CountA method Range.Delete method Worksheet.UsedRange property Range.Count property Range.EntireRow property Range.Rows property For...Next statement

Learn

Excel Macro: Insert Blank Rows Between Existing Rows

If you need to insert blank rows between each of the existing rows into your Worksheet with VBA, this macro will help you to do this.

Range.Insert method Range.Count property For...Next 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.Count property

Returns a Long value that represents the number of objects in the collection. Syntax expression.Count expression A variable that represents a Range […]

Range.Count property

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