vba单元格区域引用方式的小结（国外英文资料）.doc

vba单元格区域引用方式的小结（国外英文资料） When using ExcelVBA for programming, we usually need to refer to the cell area frequently, and then use the corresponding properties and methods to manipulate the region. A cell region refers to a single cell, or a region composed of multiple cells, or an entire row, an entire column, etc. Below, we set up a few scenarios to generalize the way we refer to the cell region in the form of a question and answer session. -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Question 1: how do you reference single cells in the current worksheet (such as reference cell C3) in the VBA code? Answer: you can use any of the following examples to reference the cell (C3) in the current worksheet. (1) Range ( C3 ) (2) [C3] (3) Cells (3, 3) (4) Cells (3, C) (5) Range ( C4 ).offset (-1) Range ( D3 ).offset (-1) Range ( A1 ).offset (2, 2) (6) if C3 is the current cell, it can be used: ActiveCell (7) if the C3 cell is named Range1, it can be used: Range ( Range1 ) or [Range1] (8) Cells (4, 3).offset (-1) (9) Range ( A1 ). Range ( C3 ) -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Question 2: in the VBA code, I want to refer to the B2: D6 cell region in the current worksheet. What are the methods? Answer: you can use any of the following examples to refer to the cell region B2: D6 in the current worksheet. (1) Range ( B2: D6 ) (2) Range ( B2 , D6) (3) [B2: D6] (4) Range (Range ( B2 ), Range ( D6 )) (5) the Range (Cells (2, 2), Cells (6, 4) (6) if you name the zone B2 as MyRange, you can use the following statement to reference the area: So, Range ( MyRange ) (2) [MyRange] (7) Range ( B2 )