Question: QUESTION 12 Consider the following code. It is intended to go through each worksheet in the active workbook and write IDS 331 in cell A1,

QUESTION 12 Consider the following code. It is

QUESTION 12 Consider the following code. It is intended to go through each worksheet in the active workbook and write "IDS 331" in cell A1, "VBA" in cell A2, and the number of the current worksheet in cell A3. Each blank is numbered, e.g. 1 is the blank numbered 1, match the numbered blanks to their answers. _2________ is the blank numbered 2, etc. The goal is to Dim wsitem As__1______ _______________ counter As Integer counter = 1 For Each _3______ In 4 .Range("A1").Value = "IDS 331" _6____ .Range("A2").Value = "VBA" .Range("A3").Value = counter counter = _____8____+1 Next wsitem Answer the following 8 questions individually (each is worth 12.5% of the worth of this question). Note that different questions may have the same answer option. - What should be in the blank numbered 1? A. Range B. Dim What should be in the blank numbered 2? C. Workbooks D. Worksheet E. Worksheets What should be in the blank numbered 3? What should be in the blank numbered 4? What should be in the blank numbered 5? What should be in the blank numbered 6? What should be in the blank numbered 7? What should be in the blank numbered 8? F. counter G. ActiveSheet H.wsltem 8 points Save

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!