VBA-Excel: CurrentRegion
CurrentRegion analyses the filled cells and the blank cells surrounded by the rangeyou provide. Its returns a Range object as a region in Mxn shape.
Syntax:
RangeObject. CurrentRegion
Example:
Function FnCurrentRegion()
Dim mainWorkBook As Workbook
Set mainWorkBook = ActiveWorkbook
With mainWorkBook.Sheets("Sheet1")
.Range("H2").Value = 5
.Range("I3").Value = 15
.Range("H2").Activate
End With
ActiveCell.CurrentRegion.Select
End Function
Current Region
Hello there, just became aware of your blog through Google, and found that
it’s really informative. I’m gonna watch out for brussels.
I’ll be grateful if you continue this in future. Lots of people will be benefited
from your writing. Cheers!