Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Here is aworksheet with the spending of some people on their meals ina day. Spendings 2 Name Breakfast Lunch Tea Dinner 3 Brenda 30
Here is aworksheet with the spending of some people on their meals ina day. Spendings 2 Name Breakfast Lunch Tea Dinner 3 Brenda 30 85 25 50 4 Candy 5 Dennis 6 Anthony 7 Amy 22 44 78 92 18 40 49 30 20 38 25 30 80 Cells B3 to E7 are then selected. B. D. Spendings Tea 2 Name Breakfast Lunch Dinner 3 Brenda 4 Candy 5 Dennis 6 Anthony 7 Amy 30 85 25 50 22 44 78 92 18 40 49 30 20 38 25 55 30 80 Next, a VBA macro is run while the cells are selected. The macro will highlights the names of the people whose spending of any meals is higher than or equal to 50. Here is the VBA macrowith some missing code: Sub HighlightMeals() Dim ThisCell As Range Cells.Interior.Colorindex = x1None For Each Thiscell In If Thiscell.Value >= 50 Then Blank 1 Cells( 8lank 2, 1). Interior.Color = vbYellow End If Next ThisCell End Sub After running the VBA macro, the worksheet becomes: B. D. Spendings 2 Name Breakfast Lunch Tea Dinner 3 Brenda 4 Candy 5 Dennis 6 Anthony 7 Amy 30 85 25 50 22 44 78 92 18 40 49 30 20 38 25 55 30 80 8. You need to fill in the blanks in the code so that the macro performs as described above. You need to write the answers clearly in the boxes below. Do not add 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
Step by Step Solution
★★★★★
3.41 Rating (154 Votes )
There are 3 Steps involved in it
Step: 1
Please find the code below ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started