Chapter 7
Content
Chapter 7
Essential VBA Language Elements
Dim x As Integer, y As Integer, z As Integer Dim First As Long, Last As Double
Chapter 8
Working with Range Objects
When you refer to a Range object, the address is always surrounded by double quotes, like this: Range(“A1:C5”) Or if the range has a name (created by using FormulasâȘNamed CellsâȘName A Range), you can use an expression like this: Range(“PriceList”)
Chapter 9
Using VBA and Worksheet Functions
Using Worksheet Functions in VBA
Essential VBA Language Elements
Dim x As Integer, y As Integer, z As Integer Dim First As Long, Last As Double
Chapter 8
Working with Range Objects
When you refer to a Range object, the address is always surrounded by double quotes, like this: Range(“A1:C5”) Or if the range has a name (created by using FormulasâȘNamed CellsâȘName A Range), you can use an expression like this: Range(“PriceList”)
Chapter 9
Using VBA and Worksheet Functions
Using Worksheet Functions in VBA
