worksheet has two properties: “name” (1) name on the sheet tab Name—the (2) name used by VBA CodeName—the Set the CodeName using the property “(Name)” in the worksheet dialog box. The following has been named by the user “Calculations” (that shows up in the worksheet tab within Excel), while it has been given the CodeName “wsCalcs”. Then you can refer to Cell B6 of as: “Calculations” wsCalcs.Range(“B6”) Properties of Ranges Cells: refers to a specific cell in a range references cell D4 Range(“B3:B10”).Cells(4) references cell B6 references cell E3 Range(“B3:F3”).Cells(4) Column: returns the number of the 1st column in the range returns 2 Range(“D3:F7”).Column returns 4 EntireColumn: references the entire columns in the range (like clicking on the column labels)
worksheet has two “name” properties: (1) Name—the name on the sheet tab (2) CodeName—the name used by VBA Set the CodeName using the “(Name)” property in the worksheet dialog box. The following has been named “Calculations” by the user (that shows up in the worksheet tab within Excel), while it has been given the CodeName “wsCalcs”. Then you can refer to Cell B6 of “Calculations” as: wsCalcs.Range(“B6”) Properties of Ranges Cells: refers to a specific cell in a range references cell D4 Range(“B3:B10”).Cells(4) references cell B6 Range(“B3:F3”).Cells(4) references cell E3 Column: returns the number of the 1st column in the range returns 2 Range(“D3:F7”).Column returns 4 EntireColumn: references the entire columns in the range (like clicking on the column labels)
MgtOp-470-Topic-3-Set-2.docx