Here is a VBA macro which changes the colour of some cells inside the currently selected...

Transcribed Image Text:

Here is a VBA macro which changes the colour of some cells inside the currently selected cells. Sub Draw() Dim Cell As Range For Each Cell In Blank 1 If Cell.Row Blank 2 Cel11.column Then Cell.Interior.ColorIndex = 1 End If Next Cell End Sub After running the above macro, the following display is shown in the selected area of cells. ABCDIE GH MNO DIQRS TU 10 12 You need to fill in the blanks in the code so that the above display can be created inside the selected area of cells. You need to write the answers clearly in the boxes below. Do not write any spaces in the answers. For example, if you need to write an expression such as A + B. you will write A+B without any spaces in between. Blank 1 is Blank 2 is Here is a VBA macro which changes the colour of some cells inside the currently selected cells. Sub Draw() Dim Cell As Range For Each Cell In Blank 1 If Cell.Row Blank 2 Cel11.column Then Cell.Interior.ColorIndex = 1 End If Next Cell End Sub After running the above macro, the following display is shown in the selected area of cells. ABCDIE GH MNO DIQRS TU 10 12 You need to fill in the blanks in the code so that the above display can be created inside the selected area of cells. You need to write the answers clearly in the boxes below. Do not write any spaces in the answers. For example, if you need to write an expression such as A + B. you will write A+B without any spaces in between. Blank 1 is Blank 2 is

Answer rating: 100% (QA)

Blank1 is RangeD3T11 Blank... View the full answer