2.对象属性

1.属性--打印用msgbox

'MsgBox Application.Name
'MsgBox Application.Version
'MsgBox Sheet3.Name
'MsgBox Worksheets(3).Name
'MsgBox Worksheets("Sheet1").Name

2.修改属性值

修改活动单元格的值

ActiveCell.Value = 100

修改活动单元格的行高

ActiveCell.RowHeight = 40

修改A1单元格内容为40

[a1] = 40

修改B1和C1单元内容为50

[b1:c1] = 50

修改D1到E8单元格内容为25

Range("d1:e8") = 25

指定鼠标框选位置内容为50

Selection = 50