VBA(vba) excel 选择一行或一列

1、选中第1行Worksheets(Sheet1).ActivateActiveSheet.Range("1:1").Select

2、选中第2列Worksheets(Sheet1).ActivateActiveSheet.Range("B:B").Select