To refer to a particular object using VBA, the objects need to be referred to in their hierarchical structure. For example, to refer to cell A1 in a specific worksheet, the code would be ________

A) Application.Workbook (workbookname.xlsx).Worksheet("Sheet1").Range("A1")
B) Application.Worksheet("Sheet1").Range("A1")
C) Application.Workbook (workbookname.xlsx).Sheets("Sheet1").Range("A1")
D) Application.Workbook (workbookname.xlsx).Worksheet(Range("A1"))


C

Computer Science & Information Technology

You might also like to view...

The Simplex LP, Generalized Reduced Gradient Nonlinear, and Evolutionary are the three solving methods within the Solver Parameters dialog box

Indicate whether the statement is true or false.

Computer Science & Information Technology

Office Online can only be used if Microsoft Office is installed on your computer

Indicate whether the statement is true or false

Computer Science & Information Technology

Displaying subtotals at the top or bottom of a section is controlled on the PivotTable styles gallery.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

Why is it important to include documentation comments?

a. none of the answers b. instance variables c. local variable d. unit testing e. javadoc can automatically create HTML pages that describe your classes f. javadoc can automatically create Word documents that describe your classes

Computer Science & Information Technology