Suppose we were to insert a new virus after row 24 having name y73 sarcoma

Suppose we were to insert a new virus after row 24

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?
Image of page 4
Sub virus_name() ‘’virus_name Macro ‘ Macro recorded 10/6/99 by CS 3 rd Floor Labs Range(“B6:D24”).Select Selection.Sort Key1:=Range(“B6”), Order1:=xlAscending,_ Header:=xlGuess, OrderCustom:=1, MatchCase:=False,_ Orientation:=xlToptoBottom End Sub 65. Give three frequently relevant and important reasons why one would name a cell rangein Excel.
Image of page 5
Image of page 6

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture