United States (English) Sign in
Home Products Office 365 Docs Samples Downloads Training How To Support Forums
Office and SharePoint development > Office client development > Office 2010 > Excel 2010 > Excel 2010 Developer Reference > Reference > Range Object > Properties > Range.CurrentArray Property (Excel)
Office and SharePoint development
Office client development
Office 2010
Excel 2010
Excel 2010 Developer Reference
Reference
Range Object
Properties
Range.AddIndent Property (Excel)
Range.Address Property (Excel)
Range.AddressLocal Property (Excel)
Range.AllowEdit Property (Excel)
Range.Application Property (Excel)
Range.Areas Property (Excel)
Range.Borders Property (Excel)
Range.Cells Property (Excel)
Range.PivotCell Property (Excel)
Range.Characters Property (Excel)
Range.Column Property (Excel)
Range.Columns Property (Excel)
Range.ColumnWidth Property (Excel)
Range.Comment Property (Excel)
Range.RowHeight Property (Excel)
Range.Count Property (Excel)
Range.CountLarge Property (Excel)
Range.Creator Property (Excel)
Range.CurrentArray Property (Excel)
Range.CurrentRegion Property (Excel)
Range.Dependents Property (Excel)
Range.DirectDependents Property (Excel)
Range.DirectPrecedents Property (Excel)
Range.DisplayFormat Property (Excel)
Range.End Property (Excel)
Range.EntireColumn Property (Excel)
Range.EntireRow Property (Excel)
Range.Errors Property (Excel)
Range.Font Property (Excel)
Range.FormatConditions Property (Excel)
Range.Formula Property (Excel)
Range.FormulaArray Property (Excel)
Range.FormulaHidden Property (Excel)
Range.FormulaLocal Property (Excel)
Range.FormulaR1C1 Property (Excel)
Range.FormulaR1C1Local Property (Excel)
Range.HasArray Property (Excel)
Range.HasFormula Property (Excel)
Range.Height Property (Excel)
Range.Hidden Property (Excel)
Range.HorizontalAlignment Property (Excel)
Range.Hyperlinks Property (Excel)
Range.ID Property (Excel)
Range.IndentLevel Property (Excel)
Range.Interior Property (Excel)
Range.Item Property (Excel)
Range.Left Property (Excel)
Range.ListHeaderRows Property (Excel)
Range.ListObject Property (Excel)
Range.LocationInTable Property (Excel)
Range.Locked Property (Excel)
Range.MDX Property (Excel)
Range.MergeArea Property (Excel)
Range.MergeCells Property (Excel)
Range.Name Property (Excel)
Range.Next Property (Excel)
Range.NumberFormat Property (Excel)
Range.NumberFormatLocal Property (Excel)
Range.Offset Property (Excel)
Range.Orientation Property (Excel)
Range.OutlineLevel Property (Excel)
Range.PageBreak Property (Excel)
Range.Parent Property (Excel)
Range.Phonetic Property (Excel)
Range.Phonetics Property (Excel)
Range.PivotField Property (Excel)
Range.PivotItem Property (Excel)
Range.PivotTable Property (Excel)
Range.Precedents Property (Excel)
Range.PrefixCharacter Property (Excel)
Range.Previous Property (Excel)
Range.QueryTable Property (Excel)
Range.Range Property (Excel)
Range.ReadingOrder Property (Excel)
Range.Resize Property (Excel)
Range.Row Property (Excel)
Range.Rows Property (Excel)
Range.ServerActions Property (Excel)
Range.ShowDetail Property (Excel)
Range.ShrinkToFit Property (Excel)
Range.SoundNote Property (Excel)
Range.SparklineGroups Property (Excel)
Range.Style Property (Excel)
Range.Summary Property (Excel)
Range.Text Property (Excel)
Range.Top Property (Excel)
Range.UseStandardHeight Property (Excel)
Range.UseStandardWidth Property (Excel)
Range.Validation Property (Excel)
Range.Value Property (Excel)
Range.Value2 Property (Excel)
Range.VerticalAlignment Property (Excel)
Range.Width Property (Excel)
Range.Worksheet Property (Excel)
Range.WrapText Property (Excel)
Range.XPath Property (Excel)
Expand Minimize
This topic has not yet been rated - Rate this topic

Range.CurrentArray Property (Excel)

Office 2010

If the specified cell is part of an array, returns a Range object that represents the entire array. Read-only.

expression .CurrentArray

expression A variable that represents a Range object.

This example assumes that cell A1 on Sheet1 is the active cell and that the active cell is part of an array that includes cells A1:A10. The example selects cells A1:A10 on Sheet1.

VBA
Copy 
ActiveCell.CurrentArray.Select
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.