What is "UsedRange"???

[teebruin]

I am looking at some VBA code in an excel macro, and I was hoping that someone could explain to me what UsedRange is.

The particular line of code is:

Set Rng = ActiveSheet.UsedRange.Rows

 

[Mark O'Brien]

UsedRange returns a rectangular range which goes from the upper left populated cell in the spreadsheet, to the lower right populated cell.

e.g. if A1 has "1" in it and C6 has "4" in it, the used range will return the range "A1:C6".

 

[teebruin]

Thanks a bunch, that helped.

 

[fdrl]

On 2002-04-18 10:22, Mark O'Brien wrote:
UsedRange returns a rectangular range which goes from the upper left populated cell in the spreadsheet, to the lower right populated cell.

e.g. if A1 has "1" in it and C6 has "4" in it, the used range will return the range "A1:C6".

The top left and bottom right cells of the used range are not necessarily populated.

The top left cell is the intersection of the first used column and the first used row.

The bottom right cell is the intersection of the last used column and the last used row.

 

[aprildu]

Re: What is "UsedRange"???

The difference of currentrange and usedrange is cells are populated in currentrange but not necessarily in usedrange?