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