What does Range do in excel?

is the range of the region to be selected in the formula, for example, the syntax of sumif is: sumif(range,criteria,sum range).

sumif(a1:a10,">100"), which means that the values in the a1:a10 region that match 100 are summed, and the third parameter is omitted.

It's a range, and it's an object in VBA.

range, the target region address is the parameter.

This function dynamically fetches the range in a loop.

range("b" & i & ":h"& i) The format is correct.

The commonly used format is:

range("a1", "b4").selectrange("a2:b4").select

In Excel's VBA programming, it is very commonly used to return the function of range through strings, and then further operate on range, here the hydrology toolset introduces a practical VBARANGE function rangeFromAddress, the specific source is as follows:

The rangefromaddress above also references two functions, as follows.

getobjectparentsheet(aobject as object) as object

op as object

error resume next

04.aobject is nothing then goto errorexit

op =op is nothing then goto errorexit

08.typeof op is workbook then

getobjectparentsheet = aobject

errorexit

if13.op =

17.typeof op is worksheet then setgetobjectparentsheet = op

function

function

getobjectparentworkbook(aobject asobject) as workbook

o as object

27.error goto errorhandle

29.aobject is nothing then goto errorexit

o =32.

typeof aobject is workbook then

getobjectparentworkbook = aobject

errorexit

if37.o =41.

typeof o is workbook then setgetobjectparentworkbook = o

function

errorexit

function

I don't understand, do you want to select the cell in column B corresponding to the first blank cell in column E, if so, you can try the following **.

sub ylc120()

e65536").end(xlup).offset(1, -3).select

end sub

Change the value in the offset to adjust to the cell you want.

You can also use the following format.

range("a1:b" & i & ", d1:e" & i & "")

You have to distinguish between the variables and the characters in the string.

To understand the usage of double semicolons and &.

Remember to add a space between & and i.

The format is correct.

range (target area address).

The target area is in text format.

or range(cells(2,2),cells(3,3)), which is commonly used.

Common usage of range.

1.Represents the cell.

range("a1") represents the cells in the first column of the first row, essentially the same as cells(1,1). Both are the same in this case, but the relationship between the two can be understood in such a way that a range object is a collection of cell objects. The range object cannot represent a cell like cells(i,j)."ij"This is a point to note!

2.Represents a contiguous area.

There are two expressions of the range object to represent a continuous region: the first is range("Start cell","End cell"), the second is range("Start Cell: End cell"As shown in the figure below, I want to select the (A1:B4) area, Program:Sub object range().

range("a1", "b4").select

range("a2:b4").select

end sub

3.Represents a discontinuous area.

For discontinuous regions, the expression of range is: range("Start cell 1: End cell 1, start cell 2: End cell 2"For example, I want to select (A1:B2) and (B3:C4) to connect regions.

Program: sub object range().

range("a1:b2,c3:d4").select

end sub

4.Represents rows and columns.

Since the range can be used to represent the area, then the rows and columns can also be represented, for example, if I want to select the first row, I can do this with range("1:1"if you want to represent the first column range("a:a")

Procedure: sub range usage ().

range("1:1").select

range("a:a").select

end sub

copy method.

After a range object is selected, it can be copied to this area.

Procedure: sub range usage ().

range("a1:b4").copy

end sub

The object is combined with with.

The combination of the range object and the with can make the program very simple, take a look at the following example:

Procedure: sub range usage ().

with range("a1").font

size = 16

colorindex = 24

fontstyle = "bold"

end with

end sub