Rangea7select added end sub here are some of the

Range(“A7”).Select (added)
End Sub
Here are some of the formulas in the worksheet:
C3=MAX(A7:A10)+1
F7=D7+F3
F8=F7-D8+E8
F9=F8-D9+E9
F10=F9-D10+E10
See the red text.
Question 57
Here is a screen snapshot of a worksheet: I failed to copy the snapshot here.
Here is a macro that goes with this worksheet:
Sub virus_name()
‘‘ virus_name Macro
‘ Macro recorded 10/6/99 by CS 3rd Floor Labs
Range("B6:D24").Select
Suppose we were to insert a new virus after row 24 having name"y73 sarcoma virus," size 0.30, and
host species Chicken. The above macro would no longer work. Why not? What is the best way to
deal with the problem (i.e. how would you change the macro to avoid the need for further changes
whenever data is added to the worksheet)?
Question 58 Give three (3) frequently-relevant and important reasons why one names cell ranges in
Excel .