100%(6)6 out of 6 people found this document helpful
This preview shows page 4 - 6 out of 6 pages.
64. 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?
Sub virus_name()‘’virus_name Macro‘ Macro recorded 10/6/99 by CS 3rdFloor LabsRange(“B6:D24”).SelectSelection.Sort Key1:=Range(“B6”), Order1:=xlAscending,_Header:=xlGuess, OrderCustom:=1, MatchCase:=False,_Orientation:=xlToptoBottomEnd Sub65. Give three frequently relevant and important reasons why one would name a cell rangein Excel.