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...

Which of the following functions would NOT be used to construct an amortization table?

A) CUMPRINC B) PV C) IPMT D) PPMT

Computer Science & Information Technology

Which best describes kinesthetic learners?

A. learn by watching presentations B. work well with hands-on environments C. learn best through lectures D. tend to like taking notes

Computer Science & Information Technology