Private Sub CommandButton1_Click()
Sheets("A").Cells(1, 1).Value = "ABCDE"
With Sheets("B")
.Activate
.Range(.Cells(37, 1), .Cells(37, 5)).Select
End With
End Sub
----------------------------------------------------------------
这个代码,经过测试,应该是没有问题的!!!
Private Sub CommandButton1_Click()
Sheets("A").Cells(1, 1).Value = "ABCDE"
Sheets("B").Select
ActiveSheet.Range(ActiveSheet.Cells(37, 1), ActiveSheet.Cells(37, 5)).Select
End Sub
呵呵,疏忽了,应该用下面的语句:
Private Sub CommandButton1_Click()
Sheets("A").Cells(1, 1).Value = "ABCDE"
With Sheets("B")
.Activate
.Range(.Cells(37, 1), .Cells(37, 5)).Select
End With
End Sub
Private Sub CommandButton1_Click()
Sheets("A").Cells(1, 1).Value = "ABCDE"
Sheets("B").Activate
Sheets("B").Range(Cells(37, 1), Cells(37, 5)).Select
End Sub