vb操作EXCEL对CELLS的引用(国外英语资料).docVIP

vb操作EXCEL对CELLS的引用(国外英语资料) The common task of using Visual Basic is to specify the cell or cell range, and then perform some operations on the cell or cell region, such as entering formulas or changing formatting. You can usually perform operations with a statement that identifies cells, changes an attribute, or applies a method. In Visual Basic, the Range object can represent either a single cell or a cell area. The following topics illustrate the most common methods of identifying and handling Range objects. Reference cell and cell regions with the A1 style notation You can use the Range property to refer to the cell or cell range in the A1 reference style. The following subroutine sets the font for the cell area A1:D5 to bold. Sub, FormatRange () Workbooks (Book1),.Sheets (Sheet1),.Range (A1:D5), .Font.Bold = True End Sub The next show shows some A1 style references using the Range property. Reference meaning Range (A1) cell A1 Range (A1:B5) from cell A1 to cell B5 Range (C5:D9, G9:H16) multiple selected areas Range (A:A) A column Range (1:1) first line Range (A:C) from the column A to the C column region Range (1:5) from the first line to the fifth line Range (1:1,3:3,8:8), lines first, third and 8 Range (A:A, C:C, F:F), A, C, and F columns Reference cells with numbers By using row column numbers, you can refer to a single cell using the Cells property. This property returns the Range object representing a single cell. In the following example, Cells (6,1) returns the cell Sheet1 on the A6, and then sets the Value property to 10. Sub, EnterValue () Worksheets (Sheet1),.Cells (6, 1),.Value = 10 End Sub Because variables can be substituted for numbers, the Cells property is ideal for loops in cell regions, as shown in the following example. Sub, CycleThrough () Dim Counter As Integer For Counter = 1, To 20 Worksheets (Sheet1),.Cells (Counter, 3),.Value = Counter Next Counter End Sub Note that you can use the Range property if you want to change the properties of