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