FULLY QUALIFING VARIABLES

Question 1

How do you fully qualify the worksheet and wb objects?

Answer 1

Dim ws As Worksheet
Set ws = ThisWorkbook.Worksheets (“Sheet1”)

Question 2

Write code where you are wanting to include the last row of data.

Answer 2

Dim LastRow As Long
LastRow = ws.Cells(ws.Rows.Count, “A”).End(xlUp).Row

Question 3

What is the purpose of the For….Next statement?

Answer 3

It repeats a block of statements a specific number of times:
It will use a Counter Variable whose value can be either increased or decreased with each repetition of the loop.

Question 4

Which VBA function references a single cell at a time?

Answer 4

Cells function

Question 5

VBA code: Worksheets(“Sheet1”).Cells - is referencing what?

Answer 5

Every single cell in the entire sheet (the only time it doesn’t reference a single cell).

Question 6

What cell does this code reference: Worksheets(“Sheet1”).Cells(3)?

Answer 6

C1

Question 7

Write VBA using cell reference for D15.

Answer 7

Worksheets(“Sheet1”).Cells(15,4)

Question 8

You can using the actual column letter - do so using cell function for D15:

Answer 8

Cells(15, “D”)

Question 9

Are you allowed to use the column letter inside of a cell function?

Answer 9

yes

Question 10

Is it a good idea to use a loop with a Range function?

Answer 10

No - because the references for cells aren’t numbers.

Question 11

What would be a workaround for using loops and the Range function?

Answer 11

You can embed the Cells functions inside of a Range Function.

Question 12

What is the value of using the Cell function inside of a Range function?

Answer 12

You can write dynamic code using Loops - using just the Range function does not do this.