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