Home ยป Range.Address property
Learn
Excel Macro: Create a PivotTable Checklist Summary
When your workbook contains multiple PivotTables, it is often helpful to have a checklist summary that outlines the basic details of the […]
Range.AutoFit method Application.ConvertFormula method PivotCache.SourceData property PivotTable.CacheIndex property PivotTable.TableRange2 property PivotTable.Parent property PivotTable.Name property Worksheets.Add method PivotTable.PivotCache method Array function Range.EntireColumn property Range.Address property For Each...Next statement
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.Address property
Returns a String value that represents the range reference in the language of the macro. Syntax expression.Address (RowAbsolute, ColumnAbsolute, ReferenceStyle, External, RelativeTo) […]
Learn
Reference cells and ranges
Programming with Excel VBA: The method of reference cells and ranges. Take this free course now!