Current range will be the range used surrounded by a range. And the range which you have used in your entire worksheet is called Used Range.
For Example, you might have entered some data at Range A1:D10 and then Range A20:D30.
Current Range of A1 (or any range in A1:D10) will be Range A1:D10. Similarlly current range of A20 .. or D30 will be A20:D30.
And the used range of the worksheet will be A1:D30.
One worksheet can have one or more current regions, and only one used range. So, used range will be collection of current regions.
Current region will be used to change the formats or calculations to particular block of range (region). And used range will be used to deal with the entire used range in the worksheet.
Current region will connected with at least on data cell (non empty cell). And the used ranges will consider if any range or cell is used once and even if the cell is blank.
You can used the below procedure to find the used range in a worksheet.
As explained above, once you use any range it will be considered as used cell even after deleting the content in the cell. To get the used range with the data, please refer our examples on finding actual used range in the worksheet.