Excel VBA PPT讲义.ppt

1、以下是Excel VBA、Range对象的属性以及Range对象最有用的一些属性：Address此属性返回Range的当前位置。Count此属性用于确定Range中的单元格数。公式此属性返回用于计算显示值的公式。Offset此属性对于从一个Range移动到另一个Range很有用。Resize允许您设置当前选定范围的大小。Value返回Range的数值。是，thisworkbook.worksheets (sheet1)。范围(B1)。activate activecell.offset (2，2)。activate msgbox the current active cell is activ

2、e cell . address msgbox the value of C5 is range(C5)。value msgbox the formula of C5 is range(C9)。公式、单元格数、thisworkbook.worksheets (sheet1)。活动范围(a 1: f 5)。select msgbox the current active range count is selection . count，示例，Sub boldeveryother()dim I counter as integer for I counter=范围(a 1: c125)。rows

3、. count step 2 this work book . work sheets(sheet 1)。范围(a 1: c 25)。I counter(rows)。font.bold=true next end sub，应用range的with，Range(a 13360 a 6)。numberformat=#，# # 0.00范围(a 1: a 6)。font . name=courier new range(a 13360 a 6)。font . font style=regular range(a 1: a 6)。font . size=11 range(a 13360 a 6)。fo

4、nt . strike through=false range(a 1: a 6)。font . superscript=false range(a 1: a 6)。font . subscript=false range(a 1: a 6)。font . outline font=false range(a 1: a 6)。font . shadow=false range(a 13360 a 6)。font . underline=xlunderlinestyleonerange(a 13360 a 6)。font.colorindex=XL automatic，range with用法，with range(“a 13360 a 6”)。numberformat=#，# # 0.00 with font . name= courier new 。font style= regular 。size=11 . strike through=false . superscript=false . subscript=false . outline font=false，shadow=false . un