To Refer to a Particular Object Using VBA,the Objects Need

Multiple Choice

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) .Sheets("Sheet1") .Range("A1")
B) Application.Workbook (workbookname.xlsx) .Worksheet("Sheet1") .Range("A1")
C) Application.Worksheet("Sheet1") .Range("A1")
D) Application.Workbook (workbookname.xlsx) .Worksheet(Range("A1") )