Range A1 to E10 Range(Cells(1,1),Cell(10,5)) Column A Range(“A:A”) Column A [A:A] Row 5 Range(“5:5”) Row 5 [5:5] Sheet called Sheet1 Sheets(“Sheet1”) Worksheets called Sheet1 Worksheets(“Sheet1”) Second worksheet in workbook Sheets(2) Third worksheet in workbook Worksheets(3) Cell A1 in Sheet1 Worksheets(“Sheet1”).Range(“A1”) Cell A1 in Sheet1 [Sheet1].[A1] The sheet after the active sheet ActiveSheet.Next Workbook file called Test.xls Workbook(“Test”) Navigation in a worksheet using Offset Sub MoveDown() ActiveCell.Offset(1, 0).Select End Sub Sub MoveUp() ActiveCell.Offset(-1, 0).Select
Range(Cells(1,1),Cell(10,5)) Range A1 to E10 Range(“A:A”) Column A [A:A] Column A Range(“5:5”) Row 5 [5:5] Row 5 Sheets(“Sheet1”) Sheet called Sheet1 Worksheets(“Sheet1”) Worksheets called Sheet1 Sheets(2) Second worksheet in workbook Worksheets(3) Third worksheet in workbook Worksheets(“Sheet1”).Range(“A1”) Cell A1 in Sheet1 [Sheet1].[A1] Cell A1 in Sheet1 ActiveSheet.Next The sheet after the active sheet Workbook(“Test”) Workbook file called Test.xls Navigation in a worksheet using Offset Sub MoveDown() ActiveCell.Offset(1, 0).Select End Sub Sub MoveUp() ActiveCell.Offset(-1, 0).Select
Excel%20VBA%20Course%20Exercises%2014-3-13.docx