Worksheet.UsedRange property Archives

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!

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: 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

Docs

Worksheet.UsedRange property

Returns a Range object that represents the used range on the specified worksheet. Read-only. Syntax expression.UsedRange expression A variable that represents a […]

Worksheet.UsedRange property

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