Microsoft Excel Training- From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

Excel Current Region

| | Information Helpful? Why Not Donate.

Current Special! Complete Excel Excel Training Course for Excel 97 - Excel 2003, only ~~$145.00~~. $59.95 Instant Buy/Download, 30 Day Money Back Guarantee & Free Excel Help for LIFE!

CURRENTREGION PROPERTY
Returns a RangeObject that represents the current region. The current region is bounded by any combination of blank rows and blank columns. Read-only.

Example
If the Areas A1:C10, A12:C20 were occupied but A11:C11 were blank and A1 was active the macro below would return "$A$1:$C$10"

Sub MyCurrentRegion

  MsgBox ActiveCell.CurrentRegion.Address

End Sub

EXCLUDE HEADINGS
See Omit Headings

Instant Download and Money Back Guarantee on Most Software

Microsoft Excel Training- From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Microsoft � and Microsoft Excel � are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft