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