We can see in the above screenshot that the UsedRange is A1:D5. We can also select the last used cell by pressing the CTRL+END keys on the keyboard.įollowing is an illustration of a UsedRange in a worksheet: We can describe a ‘Used Cell’ as a cell containing any formula, formatting, value, etc. It is a property representing the area covered or bounded by the top-left used cell and the last right-used cells in a worksheet.
The UsedRange in VBA is a worksheet property that returns a range object representing the range used (all Excel cells used or filled in a worksheet) on a particular worksheet. Examples of Excel VBA UsedRange Property.
0 kommentar(er)
