VBA入门的基础语句-详解（国外英文资料）.docVIP

VBA入门的基础语句-详解（国外英文资料） The basic statement of the VBA entry - detailed solution Select a worksheet: ( Balance ). Activate. Select cells: Range ( A1 ). The Select Select a contiguous cell: Range ( A1: G8 ). Select Select a discontinuous cell: Range ( A1, B6, D9 ).select Range ( A1, B6: B10, D9 ).select Select the working book for the current activity: ThisWorkbook. Activate If you choose another workbook, note that the workbook must be open, and dont forget to add the suffix .xls for example: Windows ( Totol. XLS ) Select a worksheet: ( Balance ). Activate. Cell move: ActiveCell. Offset (13, 14)